Encrypting Connections to SQL Server
I manage databases for financial organisation. These databases have confidential data of our customers such as credit card numbers, security...
2012-07-16
5,670 reads
Basit's SQL Server Tips
Introducing Windows Server 2012 – Get the FREE eBook!
Introducing Windows Server 2012 - can be downloaded for free here.
This book provides the early, high-level information you need to begin preparing...
2012-07-14
2,265 reads
Retrieving password policy settings for SQL login accounts
Today, I wrote the following query for our internal audit report for SAS70. This query provides all the necessary details...
2012-07-10
3,425 reads
Purging MSDB Backup and Restore History Tables
Today while checking our database growth reports, I noticed that size of msdb database on most of our SQL Server...
2012-07-09
2,467 reads
Securing Database Contents with Transparent Data Encryption (TDE)
Introduction
Microsoft SQL Server has many security features available within the database, but until release of SQL Server 2008 there has...
2012-07-08
7,767 reads
Find the size of Index in SQL Server
As we know, sp_spaceused gives the size of table and index but it gives the sum of size of all...
2012-07-06
7,387 reads
View SQL Server information using Transact-SQL script
Recently one of our clients requested information about their SQL Server infrastructure which we manage. In order to complete this...
2012-07-13 (first published: 2012-07-04)
9,062 reads
Useful new DMV’s in SQL Server 2008 R2 SP1 and SQL Server 2012
Introduction
Microsoft SQL Server 2008 R2 and SP1 and SQL Server 2012 has a new set of DMVs that includes sys.dm_server_memory_dumps,...
2012-07-03
5,411 reads
Determine space used for each table in a SQL Server database
I have written following Microsoft SQL Server T-SQL scirpt to quickly determine space used for each table in a SQL...
2012-07-01
4,422 reads
Rebuild indexes based on fragmentation – sp_RebuildIndex
In my previous post here, I’ve discussed how we can detect fragmentation in SQL Server databases indexes using dynamic management...
2012-06-30
5,347 reads
Blogs
SQL Server instance metadata inventory with PowerShell and SMO
By SQLPals
SQL Server instance metadata inventory with PowerShell and SMO The purpose...
5 SQL Tricks Worth Remembering Before You Close the Laptop
Disclosure: this post may contain links to books as an affiliate link. If you...
Claude Context Window
By Arun Sirpal
Every Claude conversation has a context window. It is the total amount of text...
Forums
Celebrating 30 years of PostgreSQL, A Thank you message
Comments posted to this topic are about the item Celebrating 30 years of PostgreSQL,...
provisioning sql server via VMware Cloud Foundation
Hello, has anyone here ever provisioned and actually used an MS SQL Server with...
No More Deadlocks
Comments posted to this topic are about the item No More Deadlocks
Question of the Day
No More Deadlocks
After detecting deadlocks in SQL Server 2025 and lowering the time threshold for detecting future issues, when does the Database Engine return to the 5s default interval?
See possible answers