Backup Your Certificate for TDE
If you’ve enabled TDE, you need to be sure you have a copy of the certificate that protects the Database...
2013-09-03 (first published: 2013-08-26)
1,888 reads
Blog Posts
Building an Effective Data Warehouse Architecture Presentation
I will be presenting the session “Building an Effective Data Warehouse Architecture” today at 11am CST for the PASS DBA Fundamentals...
2013-09-03
921 reads
Cumulative Update – 8 for SQL Server 2008 R2 Service Pack 2 Is Now Available !
The 8th cumulative update release for SQL Server 2008 R2 Service Pack 2 is now available for download at the...
2013-09-03
2,047 reads
Duplicate Statistics
The Setup:
Standard best practise is to have auto create and auto update statistics set for SQL Server databases. But there...
2013-09-03 (first published: 2013-08-28)
3,542 reads
Introduction to Integrity: Interpreting DBCC CHECKDB Results
I want to start a short 6 post series to serve as an introduction to integrity in SQL Server. Most...
2013-09-03
959 reads
Last Weeks Top “Reading” Links #47
It’s Tuesday, it’s time for weekly round-up #47. As an introduction, if you follow me on twitter (@StrateSQL), you’ll know that throughout the...
2013-09-03
1,024 reads
My Next Phone May Be a Nokia
I really like my Windows Phone. Yes, there are not as many apps as on a Droid or iPhone. But...
2013-09-03
548 reads
Retiring of the MCM Certifications, Part II
Image acquired from Twitter
In my recent blog post on “Retiring of the MCM Certifications”, there is a link to a...
2013-09-03
1,351 reads
SQL – Find CPU,Memory,Connections, VLF’s,I/O of all the Databases
Find CPU, Memory, No Of Connections/databases and VLF’s and I/O details in one single script.
You just need to run the...
2013-09-03
1,650 reads
SQL Server – How to Perform Striped Database Backup & Restore Using T-SQL Command
Even though there are more pros than cons, Striping database backups are often overlooked by many DBAs. Based on my...
2013-09-03
1,677 reads
Blogs
DiskANN Experiment — Exploring Entry Points and Graph Neighborhoods
Introduction I was experimenting with vector search in SQL Server 2025 using approximately 3.8...
T-SQL Tuesday #203: Risk and Reward
By Steve Jones
This is timely, as I’m currently on a boat in the Adriatic taking a...
dataMinds Connect 2026 – Slides & Scripts
You can find the slides and SQL scripts for my session “Spice up your...
Forums
Alamat Telp BCA KCP Bintaro +62 838-4945-0961
Wa:083849450961 Jl. RC. Veteran. 9, dan No.9A, RT.9/RW.3, Bintaro, Kec. Pesanggrahan, Kota Jakarta Selatan,...
Alamat Telp BCA KCP Kepa Duri +62 838-4945-0961
Wa:083849450961 Jl. Mangga Raya No.20, RT.4/RW.3, Duri Kepa, Kec. Kb. Jeruk, Kota Jakarta Barat,...
Training the next generation
Comments posted to this topic are about the item Training the next generation
Question of the Day
PostgreSQL psql Meta Commands: Databases
Which of the following meta commands (sometimes called backslash or slash commands) within psql will provide you with information about the databases on the cluster?
See possible answers