Array Element by Agonizing Array Element
Iterations and loops are fundamental parts of computer science, but with SQL and PowerShell, we may want different programming paradigms.
2017-05-17
119 reads
Editorial
2017-05-16
105 reads
Cracking the SQL Code
Checking for coding style and reviewing code is so much easier when using techniques and tools to help, as long as the tools are your slave, and not your master.
2017-05-15
228 reads
The Human Impact of a Capable AI
Computing systems and algorithms continue to improve, especially in the machine learning and AI spaces. What does that mean for us humans?
2017-05-15
69 reads
What do you do when you have a repetitive task to do?
When faced with repetitive tasks how do you go about doing them in a focused timely manner?
2017-05-11
151 reads
2017-05-08
106 reads
Three Days and a Notebook
Steve Jones is off to Seattle for the rest of the week attending Microsoft Build 2017.
2017-05-08
94 reads
2017-05-05
124 reads
2022-03-11 (first published: 2017-05-04)
304 reads
2017-05-03
147 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