(Pinal Dave) Seven years ago, I wrote a blog post about – Query to Find Seed Values, Increment Values and Current Identity Column value of the table. It is quite a popular blog post and lots of people like it as it gives immediate details about Identity Values.

(Meer Al) We would like to parameterize SSIS 2012/2014 Package connection manager with the environment variables. We would like to make sure the connection parameter picks up the value from the Environment variables during runtime.

(John Pertell) I was writing a wrap-up post to my series on FileTables when a co-worker found something interesting. SQL will insert a phantom FileTable constraint when you use SQL Server Management Studio to create a script of a non FileTable table that has a clustered index on a field named either

(Tracy McKibben) As I mentioned earlier, we use Perforce as our source control package, so all of the scripts presented here are written for Perforce. I’ll try to clearly explain, in terms of source control, the functional parts of the script, so that you can easily transfer this to your own source

(Ben Snaidero) I think that my SQL Server queries would benefit by being executed with multiple parallel threads. In some cases in the past I’ve used the MAXDOP option in my T-SQL to reduce the level of parallelism, but is there a way that I can increase the number of threads that my query uses duri

(Kathi Kellenberger) While the Reporting Wizard and basic report tables will do for prototyping, very soon we’ll want to add some finesse to our reports, and allow our report users to create different views of the same data, dynamically.

(Derik Hammer) I am a believer that regular rotation of passwords is an important security measure. I worked at an organization that, when they were small, would use the SQL Server database engine service account to run SQL Agent jobs and other processes.

(Pinal Dave) The other day I received following error when I tried to restore a database from one server to another server.

(Arthur Olcot) I was having a discussion the other day and was quite surprised to hear that there still appears to be a slight misconception regarding being able to use indexed views on web or standard editions of SQL server.

(David Dye) On several occasions I have been required to restore a database from production to development or test. The requirements are that I must restore