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,658 reads
I manage databases for financial organisation. These databases have confidential data of our customers such as credit card numbers, security...
2012-07-16
5,658 reads
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,259 reads
Today, I wrote the following query for our internal audit report for SAS70. This query provides all the necessary details...
2012-07-10
3,405 reads
Today while checking our database growth reports, I noticed that size of msdb database on most of our SQL Server...
2012-07-09
2,414 reads
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,757 reads
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,284 reads
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,047 reads
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,405 reads
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,416 reads
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,336 reads
Unused Indexes in SQL Server: Find them, vet them, and drop them safely Indexes are...
By Steve Jones
I hosted this month, late as it turns out, but we still had a...
By Brian Kelley
I'm speaking on Quantum Computing at the PASS Data Community Summit. It's scheduled for...
Comments posted to this topic are about the item Create an HTML Report on...
While doing some housekeeping activity on several old but large production databases, I come...
How important to SQL Server is the speed of the SSD and network latency?...
In SQL Server 2022, how many backup files can I have in a striped backup?
See possible answers