Dynamic SQL Crossword
This crossword is based on terms you might come across in an article about Dynamic SQL.
2018-08-08
626 reads
Editorials
2018-08-07
220 reads
I'm Not a Lawyer, But...
Over the last 18 months or so, I’ve spent a lot of time reading about the General Data Protection Regulation or GDPR. If you don’t know about it, you live under a rock, are a very old school dba, here’s a reference to the law itself. If you’re working as a data professional, I’d strongly […]
2018-08-06
85 reads
Will Terminators Be Required?
The use of terminators in T-SQL is incredibly inconsistent. Steve Jones thinks it will always be this way.
2018-08-06
83 reads
Is SQL Server Mature?
This Friday Steve Jones is wondering if the SQL Server platform does the job well enough for most people, or are there holes that need to be filled with new features.
2018-08-03 (first published: 2014-09-26)
240 reads
Handling Inconvenient Requests
Brad gives a little guidance on how you might want to respond to inconvenient requests with an eye on doing yourself a favor.
2018-08-02 (first published: 2009-12-07)
382 reads
CI and CD Aren't Magic
The techniques for Continuous Integration (CI) and Continuous Delivery (CD) don't make software better by themselves. It takes some investment and work by your staff as well.
2018-08-01 (first published: 2014-10-27)
152 reads
Have You Been Hacked?
Security is a big deal, and Steve Jones wonders if most data professionals would be aware that they had been hacked.
2018-07-31 (first published: 2014-10-30)
227 reads
When someone asks you what you do for work, how do you answer?
In many ways job titles matter, just not when telling a stranger what you do for work.
2018-07-30
451 reads
Why Volunteering May be a Bad Idea for You
Recently, as I was doing some work for the upcoming PASS Summit, a question popped in my head: “Why am I doing this?” It reminded me of the time when I was young (and idealistic). I went to the leader of a non-profit group asked about making it my permanent vocation. The leader looked at […]
2018-07-30
80 reads
Blogs
Deployment Pipelines in Fabric – What Are They?
By HeyMo0sh
In the realm of software development and content creation, the deployment pipeline serves as...
TempDB Internals – What’s New (SQL Server 2016 to 2022)
By Vinay Thakur
I wrote about TempDB Internals and understand that Tempdb plays very important role on...
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