SQL Server 2016 has reduced the NoSQL JSON “advantage” over SQL Server
Microsoft has finally implement support for JSON data in SQL Server 2016 and in Azure SQL Database. In a previous...
2016-12-20
3,637 reads
SQL Development Wizard
Invoke-SqlCmd and error results
Don’t trust Invoke-SqlCmd and error resultsI love to call Invoke-sqlcmd from powershell but one must beware of the risk of...
2016-12-19
26,983 reads
Don’t trust Invoke-SqlCmd and error results
Don’t trust Invoke-SqlCmd and error results
I love to call Invoke-sqlcmd from powershell but one must beware of the risk of...
2016-12-13
41 reads
Terminate a SSIS package after specific time interval.
Terminate a SSIS package after specific time interval.
There are several ways you can execute scheduled SSIS package/job they are:
A) SQL...
2013-06-25
8,967 reads
Run DBCC CHECKDB on a regular basis
Problem One common task as DBA is to run DBCC CHECKDB on a regular basis to detect and correct potential corruption...
2013-04-18 (first published: 2013-04-10)
11,877 reads
SQL Server Policy Based Management Alerts
SQL Server Policy Based Management Alerts
Problem
Policy-Based Management is used to enforce standards on SQL Servers and it's great. But not...
2012-12-04
4,334 reads
Running a document database on Sql Server
Running a document database on Sql Server.
Since Microsoft is slow to come out with a product of their own to...
2012-09-26
14,741 reads
Unwanted dependency between different parts of the code
Small systems tend to grow with new functionality and new access points. When the system grows, the need for data...
2012-08-16
1,119 reads
JSON and the NoSQL “advantage” over SQL Server
First what is JSON?
JSON: JavaScript Object Notation.
JSON is syntax for storing and exchanging text information, similar to XML.
JSON is smaller...
2012-06-25 (first published: 2012-06-14)
18,264 reads
Don’t Pass Null
I’ve been rereading an excellent book called “Clean Code” by Robert C. Martin. This book has some practices that each...
2012-06-08
1,209 reads
Blogs
Blog a Day – Day 1: History of AI
By Vinay Thakur
it has been a year since i have not written much on the blog...
A New Word: on tenderhooks
By Steve Jones
on tenderhooks – adj. feeling the primal satisfaction of being needed by someone, which...
Ramblings about data communities and your contributions, no excuses
By DataOnWheels
I have been active in the data community throughout my career. I have met...
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