Category: "SQL Server"

SQL Server 2014 has been released to manufacturing

Yesterday, Quentin Clark, corporate vice president of the Data Platform Group, announced that SQL Server 2014 has been released to manufacturing and will be generally available on April 1. Quentin’s blog discussed the tremendous momentum with the SQL… more »

SQL Server 2012 System Views Map

Something I forgot... we talk about, Christoph :-) SQL Server 2012 System Views Map The Microsoft SQL Server 2012 System Views Map shows the key system views included in Microsoft SQL Server 2012, and the relationships between them. The map is similar… more »

New Version of SQL Server Maintenance Solution by Ola Hallengren Now Available

Ola Hallengren and his ongoing work of his SQL Server Maintenance Solution - SQL Server Backup, Integrity Check, and Index and Statistics Maintenance.The solution is based on stored procedures, functions, the sqlcmd utility, and SQL Server Agent jobs.… more »

Discrepancy by estimated TEMPDB space for CHECKDB and CHECKALLOC - WITH ESTIMATEONlY

I came around this problem (depends on SQL Server 2008 R2 jutst to SQL Server 2012) by reading Paul S. Randal's and Ana's blog posts: How does DBCC CHECKDB WITH ESTIMATEONLY work (Paul) DBCC CHECKDB WITH ESTIMATEONLY: Do you trust it? (Ana) DBCC… more »

SQL Server 2012 Tempdb File Size Change tracked with Extended Events

We are using SQL Server 2012 and the tempdb is growing so fast. How do I effectively find what’s causing my tempdb growing. Can I monitor the file size change with Extended Events to find out the ... more »

SQL Server Information

Only a short script to get informations about your SQL Server enviroment, like machine name, instance name, edition, version, level, cluster security, user mode, collation and login. I use it as a piece on my whole admin scripts. --> SQL… more »

SQL Server 2012 Service Pack 1(SP1) Customer Technology Preview 4 (CTP4) Available

MICROSOFT® SQL SERVER® 2012 SERVICE PACK 1 (SP1), COMMUNITY TECHNOLOGY PREVIEW 4 (CTP4) Download: SQL Server 2012 SP1 CTP4 SQL Server 2012 SP1 CTP4 Express SQL Server 2012 SP1 CTP4 Feature Pack The SQL Server 2012 builds that were released after SQL… more »

Antivirus Software on SQL Server

It’s an old story, but still present - Why or why not installing antivirus software on a database server? First of all, I’ve been on both sides of the debate with respect, but I can only, only partially agree to install antivirus software on a database… more »

SQL Server 2012 - New and Modified Dynamic Management Views and Functions - DMVs

That's just about the limit. In Books Online for SQL Server 2012 (BOL) by reading What's New (Database Engine), I came around the topic Manageability Enhancements (Database Engine) and its paragraph New and Modified Dynamic Management Views and Function… more »

New Version of SQL Server Maintenance Solution by Ola Hallengren Now Available

Ola Hallengren and his ongoing work of his SQL Server Maintenance Solution - SQL Server Backup, Integrity Check, and Index and Statistics Maintenance.The solution is based on stored procedures, functions, the sqlcmd utility, and SQL Server Agent jobs.… more »