SQL Server Backup and Recovery Fundamentals Presentation
SQL Server Backup and Recovery Fundamentals – February 5th, 2013 A copy of the recording is available here. Code and slides...
2013-01-22
770 reads
TheSqlPro.com - Ayman El-Ghazali
SQL Saturday in Washington D.C. December 8, 2012
This is my first time attending a SQL Saturday event and I’m quite excited. If you live in or near...
2012-11-30
1,221 reads
What if your database server was hacked and all your data was deleted?
Recently in the news an article circulated about a coordinated attack by a team of hackers known as Anonymous. Information...
2012-11-19
502 reads
SQL Server Parallel Data Warehouse (PDW) and SQL Server Fast Track Data Warehouse
The SQL Server Parallel Data Warehouse and SQL Server Fast Track Data Warehouse are very high end builds of Microsoft’s...
2012-11-14
917 reads
SQL Server 2012 Service Pack 1 available for RTM
SP1 for the RTM of SQL Server 2012 has been announced during PASS Summit 2012. It can be downloaded here:...
2012-11-09
741 reads
Listing server and database roles for all logins and users in SQL Server – Part 3 – Using SSRS Reports to Monitor and Fix security problems
Finally the epic conclusion to my three part series about listing server and database roles. In this post I will...
2012-10-23
682 reads
Listing server and database roles for all logins and users in SQL Server – Part 2 – Remote Servers
Building upon the code in my previous post, I will be retrieving permissions information from remote servers that I have...
2012-10-15
409 reads
Listing server and database roles for all logins and users in SQL Server – Part 1 – Local Server
I was approached with a unique problem to solve; find out who has what permissions on my Database Servers. This...
2012-10-08
453 reads
Finding and removing hidden characters in your data using dynamic T-SQL
It has been a long morning for me. It was supposed to be a standard run for our quarterly data...
2012-10-05
675 reads
Running a SQL Server Environment at Home Using Native Boot Virtual Hard-Drives (VHD)
I’ve run into a road block. As a Microsoft Certified Trainer, I have all the software I need to get...
2012-09-17
1,173 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