Cumulative Update # 8 for SQL Server 2012 Service Pack 1 is now available!
The 8th cumulative update (CU8) for SQL Server 2012 Service Pack 1 is now available for download at the Microsoft...
2014-01-22
505 reads
Basit Aalishan Masood-Al-Farooq
Get SQL Server Physical Cores, Physical and Virtual CPUs, and Processor type information using Transact-SQL (T-SQL) script
Today, I received email from one of my blog follower asking if there is any DMV or SQL script, which...
2014-01-22
2,026 reads
Monitor availability groups and availability replicas status information using T-SQL
Just a quick blog post to share a query, which I wrote to monitor availability groups and replicas and the...
2014-01-20
1,802 reads
SQL Server monitoring and optimization
To optimize the performance of your database, you need to monitor and tune. You determine the performance baseline, how SQL...
2013-12-18
952 reads
Nine T-SQL best practices
SQL Server databases are the backbone of many enterprise applications, and good Transact-SQL (T-SQL) code is the best way to...
2013-12-16
958 reads
Bulk Transfers: Some guidelines
Bulk transfers are a common way of importing large amounts of data into, or exporting large amounts of data out...
2013-12-14
542 reads
How to work around Azure database migration limitations
Microsoft Windows Azure SQL Database, commonly known as SQL Azure, is a relational database in the cloud that is part...
2013-12-14
611 reads
Possible ways to secure SSIS Packages
SQL Server Integration Services (SSIS) security is based around several layers that provide a rich and flexible security environment. These...
2013-12-14
710 reads
SQL Server Encryption Options
Many database servers store confidential data, which must be protected from unauthorized access when it’s transmitted across the network and...
2013-12-14
679 reads
Understanding SQL Server Query Optimization – Part 2
An execution plan is the sequence of operations SQL Server query optimizer performs to run the statements. The SQL Server...
2013-12-14
1,261 reads
Blogs
Finding Balance: Things Will Come Up
By Steve Jones
I have a presentation on finding balance in your career that got quite a...
Who Are You Doing It For?
By Brian Kelley
But as I've matured over the years, I came to realize that I needed...
Presenting Twice in May 2026
By alevyinroc
I will be presenting my latest session, Documenting Your Work for Worry-Free Vacations, in-person...
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
How to change the FDLaunch Error log file location
The file FDLAUNCHERRORLOG gets created in the default <instance>\MSSQL\Log folder. So far, I've found...
what data type i should use for roversion col and can i use less than greater
can i use Rowversioncol ( in my database it's synonyme timestamp is used) to...
Question of the Day
A Fun Computer Quote
Which movie featured this quote?
"All programs have a desire to be useful."Happy April Fools! See possible answers