Latest 10 Posts
Show all index and heap access operators in the plan cache
Abstract from Service Broker Conversations (Indexed 2012-01-27):
with xmlnamespaces (default 'http://schemas.microsoft.com/sqlserver/...(truncated)... select x.value(N'@NodeId',N'int') as NodeId , x.value(N'@PhysicalOp', N'sysname') as PhysicalOp , x.value(N'@LogicalOp', N'sysname') as LogicalOp , ox.value(N'@Data...(truncated)...
The official release of System Center Advisor
Abstract from PSS SQL Server Engineers (Indexed 2012-01-27):
If you have followed this blog, you have probably seen a series of posts documenting the life of a project Ive been working on, Atlanta, to a product called System Center Advisor. Today marks the official release of that product. This has been a part...(truncated)...
How much overcapacity are you running with today? I bet SQL Azure Federations can trim that!
Abstract from TSQLNet Weblog - Cihangir Biyikoglu (Indexed 2012-01-26):
I know I already posted a whole bunch on “why use federations” or “what are federation for” but most conversations on federations, I get the question on ‘why’? so I wanted to go back to basics and what the combinat...(truncated)...
Use Existing MSDN C++ ODBC Samples for Microsoft Linux ODBC Driver
Abstract from Microsoft SQL Server Support Blog (Indexed 2012-01-26):
By Gregory Suarez | Sr. Escalation Engineer | SQL Server The CTP release of the Microsoft SQL Server ODBC Driver for Linux (http://www.microsoft.com/download/en/de...(truncated)... ) opens many opportunities for Red Hat Enterprise Linu...(truncated)...
Team Foundation Server (TFS) in the Cloud - My Experience So Far
Abstract from Carpe Datum (Indexed 2012-01-24):
I recently joined a software development project that involves not only myself and other internal Microsoft employees, but a partner and a customer as well. We are building a hybrid solution that uses assets on premises as well as Windows Azure for p...(truncated)...
How It Works: sys.dm_tran_session_transactions
Abstract from PSS SQL Server Engineers (Indexed 2012-01-24):
For some reason I have been looking at DMV output closely the last couple of weeks. I just blogged about the pending I/O requests and now I have a behavior to outline for dm_tran_session_transactions for todays blog. select * fr...(truncated)...
XEvents in SQL Server 2012: No more "lazy XML" in event harvesting scripts
Abstract from Bob Beauchemins Blog (Indexed 2012-01-23):
I've said before how thrilled I am will the new extended event UI in SSMS for SQL Server 2012. However, you might be one of the early adopters who made up their own scripts to define extended event sessions, and use hardcoded scripts to harvest t...(truncated)...
How It Works: sys.dm_io_pending_io_requests
Abstract from PSS SQL Server Engineers (Indexed 2012-01-23):
I have been working an issue where the DMV was returning io_pending_ms_ticks incorrectly. The following output is an example of ~164 hour delay. Unlikely to occur without any other side effects noted. select * from sys.dm_io_pending_io_request...(truncated)...
Assigning SQL Server, SQL Agent to a Processor Group (OOM, Hang, Performance Counters Always Zero for Buffer Pool, )
Abstract from PSS SQL Server Engineers (Indexed 2012-01-23):
Suresh brought to my attention that we have been getting questions as to why SQL Server starts on group 1 and then group 2 and it is not predictable? Then Tejas brought up another issues and since I worked on this way back before we released SQ...(truncated)...
AlwaysOn: Comapring Readble Secondary with the similar functionality available in DB2
Abstract from SQL Server Storage Engine (Indexed 2012-01-22):
As you look at other database vendors, you will realize that they also provide the functionality to offload read workload to secondary or mirror. However, if you look closer, you will realiize each vendor has significant differences on how this funct...(truncated)...
View All Posts...
Latest 10 Jobs
.Net, SQL Server Developer - MATRIX Resources, Inc. - Chandler, AZ
(Indexed 2012-01-28):
SQL Server 2000/2005/2008. - T-SQL, DTS or SSIS, SQL... SDLC VB.NET SQL Server 2000 .NET SQL Server 2008 Windows SQL C#.NET Pc... From Telegraph UK - 28 Jan 2012 06:27:41 GMT - View all Chandler jobs
SQL Server Developer - MATRIX Resources, Inc. - Atlanta, GA
(Indexed 2012-01-28):
Microsoft SQL Server 2008 Server Side development... with Transact SQL stored procedures and triggers. Good experience in SQL Server database administration... From Telegraph UK - 28 Jan 2012 06:27:44 GMT - View all Atlanta jo...(truncated)...
MS SQL Server DBA - Kforce Professional Staffing, Inc. - North Canton, OH
(Indexed 2012-01-28):
Experience Administering SQL Server Report Services Experience Administering SQL Server Analysis Services... Server Experience with SQL Server Virtualization... From JobServe USA - 28 Jan 2012 06:18:29 GMT - View all North Can...(truncated)...
SQL Server DBA - Eric Robert Associates, LLC. - Princeton, NJ
(Indexed 2012-01-28):
and configuration of SQL Server. Configuration and... of SQL server performance metrics. Writing and debugging complex SQL. Tuning poor performance SQL... From Eric Robert Associates, LLC. - 28 Jan 2012 04:19:32 GMT - View all...(truncated)...
SQL Server DBA - MISI Company - Universal City, CA
(Indexed 2012-01-28):
SQL Server technology platform and the various applications/components that leverage SQL Server.JOB... SQL Server 2000.Minimum 4 years administering SQL... From MISI Company - 28 Jan 2012 04:19:44 GMT - View all Universal City...(truncated)...
SQL Server DBA - MATRIX Resources, Inc. - Scottsdale, AZ
(Indexed 2012-01-27):
procedures & T-SQL. 3-5 years DBA experience with SQL Server 2005 & Server 2008. Proven ability to... installing SQL Server 2008 R2 in a Windows Server... From JobServe USA - 27 Jan 2012 06:10:02 GMT - View all Scottsdale jobs
SQL Server DBA with Replication - XpertTech Inc - Austin, TX
(Indexed 2012-01-27):
SQL Server DBA with ReplicationLocation: Austin, TX Duration: 3 Months Contract-to-HireBesides SQL... technical complexity of SQL Server architecture. 2... From XpertTech Inc - 27 Jan 2012 05:10:21 GMT - View all Austin jobs
C# .net SQL Server Developer - Eric Robert Associates, LLC. - New York, NY
(Indexed 2012-01-27):
Sr. C# SQL Server Application DeveloperOur client, a leading entertainment company seeks a Senior C# SQL Server developer for the following:Description... From Eric Robert Associates, LLC. - 27 Jan 2012 04:18:48 GMT - View all...(truncated)...
SQL Server Database Developer - Greensboro, NC - Genesis10 - Greensboro, NC
(Indexed 2012-01-27):
SQL Server Management Studio to develop SLQ Server... 5-7 Years experience with SQL Server Development, with a minimum of 4 years of SQL Server 2005 experience... From Genesis10 - 27 Jan 2012 04:18:11 GMT - View all Greensboro...(truncated)...
Senior SQL Server Application Developer - Collabera - New York, NY
(Indexed 2012-01-27):
experience in SQL Server development Strong SQL... skills and a strong work ethic. SQL Server 2008 R2 a plus SQL Server Analysis Services a plus... From Collabera - 27 Jan 2012 04:14:05 GMT - View all New York jobs