TOMORROW: CNJSSUG Presents - Hilary Cotter - Performance Tuning
Wednesday, August 10, 2016, The next meeting of the Central NJ SQL Server Users Group will be on Wednesday August...
2016-08-09
1,184 reads
Disk Space GUI Tool – Multi Server(s) – Grid and Email Output
Monitoring server resources is critical and important job of any Administrator. Keeping things organized might improve application availability and server...
2016-08-08
552 reads
SQL Saturday Minnesota Precon – The Complete Primer to Infrastructure Tuning
I’m pleased to announce that I’m launching my next round of all-day precon training session at the upcoming SQL Saturday in Minnesota on...
2016-08-08
396 reads
Slash star, dash dash: Be obsessive about comments
I’m working on a new session* that I’ve named “T-SQL’s Hidden Support Feature”. It’s about comments. I’ll get to the...
2016-08-12 (first published: 2016-08-08)
2,001 reads
SQL Saturday and the Alamo
I’ll be traveling this week to SQL Saturday #550 in San Antonio. This is my first time traveling to this...
2016-08-08
444 reads
Audit All Select Statements
Legislation and regulation sometimes dictates that certain activities must be tracked within a database. On occasion, it will be required that queries be audited and tracked to reach compliance...
2016-08-08
70 reads
Audit All Select Statements
Legislation and regulation sometimes dictates that certain activities must be tracked within a database. On occasion, it will be required...
2016-08-15 (first published: 2016-08-08)
2,582 reads
Top 5 books on Enterprise Architecture
My post the top 3 books for becoming TOGAF certified punlished last week looked at books on preparing for the...
2016-08-08
442 reads
Current Running Queries
Following script is perhaps the most executed script in my 10 year Database Administration career. The script has been my...
2016-08-11 (first published: 2016-08-07)
3,081 reads
Create a Date Dimension in Azure SQL Data Warehouse
Most data warehouses and data marts require a date dimension or calendar table. Those of us that have been building...
2016-08-11 (first published: 2016-08-06)
2,459 reads
Blogs
The Book of Redgate:A Prehistory
By Steve Jones
I’ve covered the values in a number of previous posts on the Book of...
Evidence-bound: what AgentDBA will and won’t link
By Arun Sirpal
When the evidence names the database, it says so. When it doesn’t, it stops....
Prep data for AI vs. Fabric Data Agent Instructions: What Goes Where?
By James Serra
Making Data AI-Ready, Part 3 (This is the final article in a three-part series...
Forums
Four Rules for Adding AI Without Breaking What Already Works
Comments posted to this topic are about the item Four Rules for Adding AI...
SQL Server 2025 section missing?
Hello, the title says it all. Is the SQL Server 2025 section missing?
A design question in a parent child relationship
I am not sure which is the best way to proceed. I have parent...
Question of the Day
Hyperscale Replicas III
In an Azure SQL Database Hyperscale Edition, how many named replicas can be configured?
See possible answers