System databases maintenance in SQL Server
Let’s talk about maintenance of system databases in MS SQL Server. There are a few differences from user databases.
At first let`s remember...
2015-08-12
2,036 reads
DevConnections Sept 14-17th 2015 – Las Vegas
DevConnections is a new conference for me and I am excited about the opportunity to present 2 different sessions. The...
2015-08-11
614 reads
T-SQL Tuesday #69–Encryption
This is a good T-SQL Tuesday topic for me. This month Ken Wilson asks everyone to write on encryption, which...
2015-08-11
910 reads
How not to do a Masters degree
There are many, many guides to successfully completing a post grad degree, so I am not going to add to...
2015-08-11
601 reads
CNJSSUG Presents: Architecting a SQL Server Availability Groups Topology - Edwin Sarmiento
Tomorrow Wednesday, August 12, 2015 at 6PM EDT, my friend and SQL MVP colleague, Edwin Sarmiento will be in town...
2015-08-11
1,183 reads
Leadership: A Name and A Principle
I’m actively working to put together the leadership course that I talked about here and here. No, not full time. I...
2015-08-11
510 reads
I’m Speaking! SQL Saturday #397 – Omaha
I recently blogged about the opportunity to speak at that the Omaha SQL Server User group. In a nutshell, being a co-founder...
2015-08-11
534 reads
Scripts and SSDT-BI 2013
Recently I tried to open a script component in SSDT-BI 2013. I was developing for SSIS 2014, so this means...
2015-08-11
1,043 reads
Compressing Encrypted Backups
A common requirement, whether it be based out of pure want or truly out of necessity, is to make a large database backup file, that is encrypted, be much...
2015-08-11
10 reads
Compressing Encrypted Backups
A common requirement, whether it be based out of pure want or truly out of necessity, is to make a...
2015-08-11
3,341 reads
Blogs
Measuring RAG Solutions: Are We Retrieving the Right Information?
A RAG pipeline that answers questions in the demo is not the same thing...
Advice I Like: Lots of Ideas
By Steve Jones
“A multitude of bad ideas is necessary for one good idea” – from Excellent...
Building a DBA Agent for Your SQL Server Estate with MCP
Yesterday I gave a talk for MSSQLTips called “Building a DBA Agent for Your...
Forums
BCA KCU Menara Bidakara Telp:0821-8200-233
Telp/WA 62 8218200233 Menara Bidakara, Jl. Gatot Subroto No.Kav.71-73 Lt. Lobby dan Lt. 1,...
Server-Level Row Counts for Tables and Views
Comments posted to this topic are about the item Server-Level Row Counts for Tables...
Parameter Sensitive Plan Optimization vs. Parameter Sniffing: What SQL Server Fixes and What It Doesn't
Comments posted to this topic are about the item Parameter Sensitive Plan Optimization vs....
Question of the Day
Hyperscale Replicas I
What types of secondary replicas are available for the Azure SQL Database Hyperscale edition?
See possible answers