SQLSat in DC – it’s a wrap
This past weekend I had the opportunity to go visit Washington DC. It was just the second time I got to stay in the Nation’s capitol for more than just...
2014-12-08
3 reads
Blog Posts
Starbucks Clover
I recently read Onward: How Starbucks Fought for Its Life without Losing Its Soul by Howard Schultz. Not bad reading...
2014-12-08
848 reads
T-SQL Tuesday #61 – Giving Back
The Season of Giving
The annual PASS Summit (otherwise known as the #SQLFamily reunion) is over. Here in the United States,...
2014-12-08 (first published: 2014-12-02)
6,433 reads
Using a date or int column as the clustered index.
The other day I was answering a question about clustered indexes and it lead indirectly to a twitter conversation on...
2014-12-08 (first published: 2014-12-01)
6,988 reads
DacFX Links
I thought it would be a good idea to gather together a list of links for DacFx, blogs code or articles - if you have anything that you think...
2014-12-07
5 reads
DacFX Links
I thought it would be a good idea to gather together a list of links for DacFx, blogs code or...
2014-12-07
45 reads
DacFX Links
I thought it would be a good idea to gather together a list of links for DacFx, blogs code or...
2014-12-07
89 reads
Make Visual Studio Setup Slightly Faster
If you get the Visual Studio 2012 or 2013 web installer then it uses the BITS service to download the setup files.
The BITS service is used to download files...
2014-12-07
4 reads
Make Visual Studio Setup Slightly Faster
If you get the Visual Studio 2012 or 2013 web installer then it uses the BITS service to download the...
2014-12-07
51 reads
Make Visual Studio Setup Slightly Faster
If you get the Visual Studio 2012 or 2013 web installer then it uses the BITS service to download the...
2014-12-07
54 reads
Blogs
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...
Deployment Pipelines in Fabric – What Are They?
By HeyMo0sh
In the realm of software development and content creation, the deployment pipeline serves as...
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