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,889 reads
Peter Skoglund
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
33 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,949 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,867 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,324 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,734 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,114 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,258 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,204 reads
A new neat feature in SQL Server 2012 is THROW
In SQL Server 2005 we got the TRY…CATCH construct which was a big help for developers to effectively handle errors...
2012-05-31
3,333 reads
Blogs
Tech Conferences and Expanding Your View
By Brian Kelley
Tech conferences aren't just for networking and learning how to address a problem you're...
Managing subscribers, creating newsletters
By DataOnWheels
When I created the website on WordPress, I was expecting all the features I...
Finding the Last Last Name in SQL: #SQLNewBlogger
By Steve Jones
I wrote a piece on the new SUBSTRING in SQL Server 2025 and got...
Forums
Getting the Schema for Tables
Comments posted to this topic are about the item Getting the Schema for Tables
An Unexciting Exciting Release
Comments posted to this topic are about the item An Unexciting Exciting Release
UNLOGGED Tables in PostgreSQL: When Speed Matters More Than Durability
Comments posted to this topic are about the item UNLOGGED Tables in PostgreSQL: When...
Question of the Day
Getting the Schema for Tables
What happens when I run this on SQL Server 2022 in the AdventureWorks2022 database?
SELECT OBJECT_DEFINITION (OBJECT_ID(N'Person.Person')) AS [Object Definition]; GOSee possible answers