Using Cell-Level Encryption in SQL Server
Industry guidance such as the Payment Card Industry Data Security Standard (PCI-DSS), Healthcare Insurance Portability and Accountability Act (HIPAA) and...
2012-07-19
15,638 reads
Basit Aalishan Masood-Al-Farooq
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,666 reads
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,264 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,058 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,421 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,441 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,763 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,351 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,410 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,420 reads
Blogs
Monday Monitor Tips: AI Query Analysis
By Steve Jones
AI is everywhere. It’s in the news, it’s being added to every product, management...
AI: Blog a Day – Day 8: RAG – Retrieval Augmented Generation
By Vinay Thakur
RAG — Retrieval Augmented Generation. we have covered so far — embeddings, vectors, vector...
AI: Blog a Day – Day 7: Vector and Vector Databases
By Vinay Thakur
Continuing from Day 6 we learned Embeddings, Semantic Search and Checks, on Day 7...
Forums
would it be so terrible to install ssms on a few user desktops?
Hi, ssms is free here. I can think of other reasons to do this...
I'm thinking about submitting some articles
I've written some documentation on using different Markdown types of files on GitHub. It's...
Not Just an Upgrade
Comments posted to this topic are about the item Not Just an Upgrade
Question of the Day
Restoring On Top I
I am doing development work on a database and want to keep a backup so I can reset my database. I make some changes and want to restore over top of my changes. When I run this code, what happens?
USE Master BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO USE DNRTest GO CREATE TABLE MyTest(myid INT) GO USE master RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACESee possible answers