Torsten Schuessler

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 »

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 »

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 »

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 »

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 »

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 »

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 »

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 »

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 »

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 »