What collation variables take on in T-SQL
I was asked an interesting question about collations in sql server recently about where variables in a script got their collation's from. I really wasn't too sure of the...
2014-10-22
8 reads
Blog Posts
Wishing You a Very Happy Diwali
Wishing You a Very Happy Diwali…………….
KAHI TIMTIMAHAT HAIN DIYO KI, KAHI SHOR HAAN ATHISBAZI KA
CHAMAK HAAN DIL MAIN, UMEEDO KI...
2014-10-22
742 reads
Consolidating Email Accounts
I am consolidating my professional email accounts into one place. If you’ve previously contacted me using my linchpinpeople.com or either...
2014-10-21
528 reads
DBAs - Step away from production
I have worked as a DBA and also as a Sql Server developer and in many roles had full access...
2014-10-21
40 reads
DBAs - Step away from production
I have worked as a DBA and also as a Sql Server developer and in many roles had full access...
2014-10-21
40 reads
DBAs - Step away from production
I have worked as a DBA and also as a Sql Server developer and in many roles had full access...
2014-10-21
15 reads
DBAs - Step away from production
I have worked as a DBA and also as a Sql Server developer and in many roles had full access to production, it is OK though I know what...
2014-10-21
3 reads
SQL Server Upgrade Preconference at PASS Summit 2014
Please join my associates and I for an all-day SQL Server Upgrade workshop on November 3rd
If you are planning an...
2014-10-21
750 reads
Tracking down CPU spikes using process explorer and DMVs
What is it about 4:45 pm on a Friday afternoon that makes CPUs spike, drives crash, databases corrupt? I wish...
2014-10-21 (first published: 2014-10-15)
8,044 reads
Add Database File on Database invloved in DB Mirroring
Database Mirroring works on transaction logs. It applies transaction logs from Principle to Mirror. But Operation like addition of file is no log operation because of that file not...
2014-10-20
6 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