(Robert Sheldon) There are several frameworks for assisting with the testing of SQL Server databases, but tSQLt is popular because it is written in TSQL and is simple for a database developer to set up and use. It doesn’t get in the way.
Tag: sql server
T-SQL 2012 Procedure sp_describe_first_result_set
(Steve Stedman) SQL Server 2012 adds a new stored procedure called sp_describe_first_result_set. This new procedure returns metadata for the result set returned from a query.
SQL SERVER – The procedure attempted to return a status of NULL, which is not allowed. A status of 0 will be returned instead.
(Pinal Dave) Here is one of the very common question I receive on SQLAuthority Facebook page. I usually answer them on Facebook but this one I find it very interesting so I decided to answer here.
Blocking SQL Server db_datareader, db_datawriter, and db_owner Permisions
(K. Brian Kelley) I’m in a dilemma. In a database I currently support, the application makes use of db_datareader and db_datawriter to give permissions to the tables. In a different database, it’s even worse as the application uses db_owner. We’re adding new tables to both databases and we don’t wan
Using Filter Settings Option in SQL Server
(Rohatash Kumar) In this article I provide a quick overview of how to use Filter Setting in SQL Server. In SQL Server you can filter records from many ways.
Loop through Flat Files in SQL Server Integration Services
(Tim Smith) Several executives tell us that they will be collecting data from thousands CSV or text files and we should expect to see at least ten new files a day. Instead of trying to import each file one by one, how can we create an SSIS package that pulls the data from each file into SQL Server w
How do I use a variable in an IN clause?
(Kenneth Fisher) I see this question in one form or another a lot. I’ve seen this or something like it probably half a dozen times in the last couple of weeks on the forums I read. To the point where it even showed up in a dream the other night (I know, weird hu?). Just to be clear I’m talking […]
SQL SERVER – Pass One Stored Procedure’s Result as Another Stored Procedure’s Parameter
(Pinal Dave) This is one of the most asked questions in recent time and the answer is even simpler.
Solving SQL VSS writer problems during backup
(Brien Posey) What are the most common SQL VSS writer issues users encounter when backing up SQL databases with VSS-based backup software?
How to Handle Gaps in Your Employment History
Steve WynKoop and I talk a lot about designing and managing our professional careers on a weekly interview on SSWUG.org. This episode was about how to handle interviews when you have a large employment gap in your resume. This article goes into more detail.