May 2015 – SQL Server Monthly Maintenance Checklist
image source
It’s time for a monthly reminder to review you SQL Server environment. Hopefully over the last few months of...
2015-05-06
672 reads
Identity Removal - WaterOx Consulting
Reading Time: 2 minutesMen In Black are not the only ones that can remove an...
The post Identity Removal appeared first...
2015-05-19 (first published: 2015-05-06)
6,426 reads
Notes on Presenting
As you may know I’m preparing to write my first presentation. I have a great abstract and an outline of...
2015-05-06
555 reads
Putting Your Head in the Clouds 1 – An introduction to Cloud Computing
By David Postlethwaite
Although the concept of Cloud Computing and Microsoft Azure have been around for a number of years it...
2015-05-06
734 reads
Debug Managed Code and Stored Procedures Seamlessly
Visual Studio is a great tool for developers, and it offers so many great features, such as IntelliSense, unit testing...
2015-05-18 (first published: 2015-05-06)
6,228 reads
Backup your SQL Server jobs using PowerShell script
This post will help you create a SQL Server job to backup all the jobs in a SQL Server Agent...
2015-05-06
195 reads
SQL Server 2016 announced… and it’s gonna rock
In what spare time I’ve had this week, I’ve been watching the news coming out of Microsoft Ignite (formerly Tech...
2015-05-06
4,742 reads
SQL Server – Changing Ownership for All the User Databases to “sa” Account
Most people prefer to have “sa” account as the database owner, primary reason being sa login cannot be removed/deleted unlike any...
2015-05-05
393 reads
Speaking at Iowa Code Camp on May 9
If you’re in the Iowa City area, come to Iowa Code Camp this weekend! They have a great lineup of speakers, covering...
2015-05-05
413 reads
Synchronizing Read / Write SQL Agent Jobs Across AlwaysOn Replicas
Intro
AlwaysOn availability groups are a powerful enhancement to SQLServer HA, and offer many improvements over older database synchronization techniques like...
2015-05-15 (first published: 2015-05-05)
6,855 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
How do I connect to a SQL Server database on my ISP?
I've got a web application for my side business. I've added a SQL Server...
Looking for New Blood
Comments posted to this topic are about the item Looking for New Blood
Server-Level Row Counts for Tables and Views
Comments posted to this topic are about the item Server-Level Row Counts for Tables...
Question of the Day
Hyperscale Replicas I
What types of secondary replicas are available for the Azure SQL Database Hyperscale edition?
See possible answers