Spend some quality time with your Database using Database Snapshots for testing
First let’s get things straight, this post is not an encouragement for anyone to spend more time with his/her Database...
2013-08-01
508 reads
TheSqlPro.com - Ayman El-Ghazali
Indexing Fundamentals Presentation – Pending Questions Answered
On July 10th 2013, I gave a presentation with the Professional Association for SQL Server (PASS) DBA Fundamentals Virtual Chapter....
2013-07-17
628 reads
Indexing Fundamentals Presentation
**This Session has been rescheduled for July 10th @ Noon EST (16:00 UTC)** On July 10th 2013 @ Noon EST (16:00 UTC)...
2013-06-26
1,254 reads
SQL Server Management Studio Rainbow Edition
Ever wanted to know the reason behind the Database color scheme in SQL Server Management Studio? I have always wondered...
2013-06-12
865 reads
How to Avoid a Database “Heart Attack”
For the past couple of months I have been working with Ben Weiss a Digital Marketing Strategist at Infusive Solutions (http://www.infusivesolutions.com/)....
2013-06-05
519 reads
Email Response: SQL Server 2012 Planning and Architecture
I received an email from a connection on LinkedIn seeking some advice for architecture on a new reporting system. Although...
2013-05-15
624 reads
Estimate Table Size based on the Metadata from INFORMATION_SCHEMA.COLUMNS
A problem I face often is not knowing the size of a new table that I’m creating. I put some...
2013-04-24
714 reads
Free SQL Server 2012 Installation Guide
Everyone’s favorite four letter word is back, FREE! Yes, it is time I gave back to the community since I’ve...
2013-04-15
358 reads
SQL Server 2012 Virtual Lab with Clustering using Hyper-V
After having a great opportunity to attend a Beta course for Hyper-V with Windows 2012 at Learning Tree, I decided...
2013-03-13
872 reads
SQL Agent and the case of the missing job owner…
One fine morning as I’m sitting at my desk doing my work I review some emails about cleaning out some...
2013-02-20
734 reads
Blogs
5 Starter Projects for Your AI and Data Engineering Portfolio
Reading tutorials is fine. Shipping something is better. If you are trying to break...
The Book of Redgate: Taking Breaks
By Steve Jones
We work hard at Redgate, though with a good work-life balance. One interesting observation...
Database AI Agents: The Read-Only Rule
By Arun Sirpal
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...
Forums
Liability for AI Errors
Comments posted to this topic are about the item Liability for AI Errors
Running a Parameter-Sensitive Stored Procedure on a Secondary Replica
Hello , I would like to run a stored procedure on a secondary replica...
Pro SQL Server Internals
Comments posted to this topic are about the item Pro SQL Server Internals
Question of the Day
Running SQLCMD II
I run this command to start SQLCMD:
sqlcmd -S localhost -E -c "proceed"At the prompt, I type this (the 1> and 2> are prompts):
1> select @@version 2> goWhat happens? See possible answers