Using Bookmarks in SQL Server Management Studio
In SQL Server one way we optimize code is by adding indexes. Indexes help queries by essentially letting the engine know “hey, here’s the fast way to get directly...
2014-11-06
14 reads
Blog Posts
VM Right-Sizing PASS 2014 Session Wrap Up
Today I presented my SQL Server virtual machine “right-sizing” session at the SQL PASS 2014 Summit to a fantastic audience....
2014-11-06
571 reads
#SQLPASS #Summit14 Day 1 Keynote Highlights !
PASS President Thomas LaRock on stage !
PASS President Thomas LaRock kicked off the summit keynote.
Tom talked about the history of...
2014-11-05
885 reads
Book: Microsoft SQL Server 2014 Business Intelligence Development Beginner’s Guide
I was fortunate to be a technical reviewer for a new book, SQL Server 2014 Business Intelligence Development by Reza...
2014-11-05
1,985 reads
Find all triggers in a SQL Server Database
What Are Database Triggers?
Do you know what triggers lurk in your database?
Triggers can be implemented to enforce business rules or...
2014-11-05 (first published: 2014-10-24)
25,603 reads
Generating T-SQL Randomly with Powershell
I have a lab on my laptop running various servers so that I can problem solve and learn and recently...
2014-11-05
554 reads
How to remove additional (unwanted) log files
Using multiple data files is a common best practice for a number of reasons, but multiple log files? Typically a...
2014-11-05
1,322 reads
Live on PASStv
My session today at the SQL PASS Summit 2014 entitled “Right Sizing Your SQL Server Virtual Machine” is going to...
2014-11-05
425 reads
Multiple AGs
Today was my pre-con with Allan Hirt on AlwaysOn. It was great, and I learned a few things. I knew...
2014-11-05
690 reads
My 1st SQL in the City Experience !
I attended my 1st #SQLinthecity event hosted by RedGate yesterday. This is one of those events which I wanted to attend...
2014-11-05
997 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