70-457 Reviewer #06, Configuring and Managing Database in SQL Server 2012
DBAs are most responsible for configuring and managing of database infrastructure, database file locations, database encryption which do not have...
2013-07-24
655 reads
Coffee and SQL
70-457 Reviewer #05, Configuring SQL Server 2012 Components
The lessons covered for this review is Configure Analysis Services Configure and Deploy Reporting Services Configure and Deploy Sharepoint Integration...
2013-07-22
576 reads
Rebuilding server level collation setting
Scenario You have just completed setting up a new development database server for a new project. After that, everyone in...
2013-07-26 (first published: 2013-07-19)
1,831 reads
70-457 Reviewer #04, Implement a Migration Strategy
Upgrading an instance is a process in which you upgrade an existing instance of SQL Server to SQL Server 2012....
2013-07-18
592 reads
70-457 Reviewer #03, Planning an Installation of SQL Server 2012
Planning an installation on SQL Server 2012 is under the Install and Configure SQL Server objective which is 19% of...
2013-07-16
659 reads
Check unused index in SQL Sever 2008
Checking for unused indices across your database should also be a part of housekeeping. Usually i would schedule checking for...
2013-07-15
364 reads
2013-07-14
292 reads
MSSQLTIPS SQL Server Webcast
MSSQLTIPS offers new webcast monthly. Topics in various areas of SQL Server are covered and perfect for all DBAs out...
2013-07-12
426 reads
SQL Server Diagnostic Information Queries for July 2013
Reblogged from Glenn Berry's SQL Server Performance: I have gone through and made some minor updates and bug fixes for...
2013-07-11
355 reads
Access denied on your SSIS SQL Server 2008
Scenario. You have a new SSIS server. All DTS packages migrated and deployed successfully to this new SSIS server. You send...
2013-07-11
348 reads
Blogs
Flyway Tips: Object History
By Steve Jones
It’s a small change, but a handy one. Flyway Desktop (FWD) now includes the...
Car Update September 2026
By Steve Jones
Software is hard. While I love our Lucid Gravity, I realize that they are...
Microsoft Tools for Making Data AI-Ready
By James Serra
Making Data AI-Ready, Part 2 (This is the second article in a three-part series...
Forums
Looking for old SQL Server 1.x - 4.21 disks, manuals, boxes, etc.
Hi everyone, I'm hoping some of the longtime SQL Server professionals here might be...
Checking the Error Log II
Comments posted to this topic are about the item Checking the Error Log II
Parameter Sniffing on SQL Server 2025: A Walkthrough with Real Numbers
Comments posted to this topic are about the item Parameter Sniffing on SQL Server...
Question of the Day
Checking the Error Log II
What is the reason I should change my old code that uses xp_readerrorlog?
See possible answers