Friday Followup For March 6, 2015
It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re...
2015-03-06
376 reads
Blog Posts
Fun-fun-fun in the London sun (and Cardiff, and Exeter!)
We’re in London right now for SQLBits, which has been ABSOLUTELY LOVELY so far. If you happen to’ve seen our...
2015-03-06
444 reads
SQLRally and SQLBits Slides and Demos
It’s been a great a busy week.
On Wednesday, I presented my session, “Query Progress Tracking in SQL Server” at SQLRally...
2015-03-06
602 reads
T-SQL :- How to Search String in all Stored Procedures across All User Defined Databases
There are many different ways to accomplish this tasks.
Download Link https://gallery.technet.microsoft.com/T-SQL-How-to-Search-String-a1704fc6
The below examples uses undocumented sp’s to loop through all the...
2015-03-06 (first published: 2015-02-24)
6,994 reads
Identifying Blocking via Extended Events
There are a number of ways that you can identify blocking that is occurring in your SQL instance. You can...
2015-03-05 (first published: 2015-02-24)
10,394 reads
Preparing a Technical Session Part 3: Writing an Abstract
So you’ve come up with a great idea for a session and now you have to translate that idea into...
2015-03-05 (first published: 2015-02-24)
5,530 reads
Data compression
This post examines the compression of a database named Bankware (BW) at a client site. The database size was about...
2015-03-04
717 reads
Data compression
This post examines the compression of a database named Bankware (BW) at a client site. The database size was 300+...
2015-03-04
274 reads
Data compression
This post examines the compression of a database named Bankware (BW) at a client site. The database size was 300+ GB. The tests for BW were done on the sk-bankware server...
2015-03-04
11 reads
Data compression
This post examines the compression of a database named Bankware (BW) at a client site. The database size was 300+ GB. The tests for BW were done on the sk-bankware server...
2015-03-04
7 reads
Blogs
T-SQL Tuesday #192: What career risks have you taken?
By James Serra
I’m honored to be hosting T-SQL Tuesday — edition #192. For those who may...
AI: Blog a Day – Day 3: LLM Models – Open Source vs Closed Source
By Vinay Thakur
Continuing from Day 2 , we learned introduction on Generative AI and Agentic AI,...
How to Parameterize Fabric Linked Services in Azure Data Factory for Azure Devops Deployment
Quite the title, so let me set the stage first. You have an Azure...
Forums
A Quick Restore
Comments posted to this topic are about the item A Quick Restore
Guarding Against SQL Injection at the Database Layer (SQL Server)
Comments posted to this topic are about the item Guarding Against SQL Injection at...
Ola Hallengren Index Optimize Maintenance can we have data compression = page
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
Question of the Day
A Quick Restore
While doing some testing of an application, I wanted to reset my environment after doing some testing with this code:
USE DNRTest BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO /* Bunch of stuff tested here */RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACEWhat happens if this runs, assuming the "bunch of stuff" isn't anything affecting the instance. See possible answers