I’m givin’ ‘er all she’s got!
Or am I?
As I proceed down the path on a consolidation project, I have taken time to pause and ponder...
2010-02-21
663 reads
Jason Brimhall
May I help you?
With the Vancouver games underway, I have been reflecting on the 2002 Winter Olympic Games. Those were the greatest winter...
2010-02-18
823 reads
DBA.Sleep(8hrs)
I have been pondering recently what helps me to sleep at night. Or, conversely, what prevents me from sleeping at...
2010-02-18
1,609 reads
DBA.Sleep(8hrs)
I have been pondering recently what helps me to sleep at night. Or, conversely, what prevents me from sleeping at...
2010-02-17
1,320 reads
In Vs. Inner Join
This is tightly related to another of my forays into tuning some slowly/poorly performing processes. This process came across my...
2010-02-16
872 reads
PayPeriod II
I recently blogged about a solution I had decided to use in order to solve a problem related to PayPeriod...
2010-02-14
794 reads
Key Discovery III
In Part I and Part II of the series, I discussed documenting and discovering Primary Keys and Clustered Indexes. In...
2010-02-11
974 reads
Relationships
This month Rob Farley is hosting TSQL-Tuesday #3. The topic is Relationships and he has left it wide open for...
2010-02-09
880 reads
Log is Filling Up
Today I ran across Paul Randal’s latest post showing how to find open transactions and such. This is a nice...
2010-02-05
527 reads
Key Discovery III
Recursively traverse system views to build a Hierarchical Perspective into the database.
Related Posts:
T-SQL Tuesday Participation Over the Years December 19, 2018
T-SQL Tuesday #104: Just Can't Cut That Cord...
2010-02-02
9 reads
Blogs
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