microsoft sql server | SQL Studies

Tag Archives: microsoft sql server

Ordering steps in a SQL Agent job
2
July 8, 2013 by Kenneth Fisher

Generally if I need to do any form of complicated control flow I’ll end up using SSIS, however there is …
Continue reading

Category: Microsoft SQL Server, SQL Agent Jobs, SQLServerPedia Syndication, SSMS | Tags: control flow, microsoft sql server, SQL Agent Jobs, SSMS
Writing Dynamic SQL (A how to)
6
July 1, 2013 by Kenneth Fisher

A little while back I wrote Best practice recommendations for writing Dynamic SQL where I made a number of suggestions …
Continue reading

Category: Dynamic SQL, Microsoft SQL Server, SQLServerPedia Syndication, T-SQL | Tags: code language, dynamic sql, language sql, microsoft sql server, sql statements, T-SQL
Using OUTPUT to back up a change
2
June 26, 2013 by Kenneth Fisher

How will you back out if your change doesn’t work?! Always take a backup! There should always be a back …
Continue reading

Category: Backups, Microsoft SQL Server, SQLServerPedia Syndication, T-SQL | Tags: backups, brent ozar, code language, disaster recovery, language sql, microsoft sql server, sql statements, T-SQL
Metadata Functions (OBJECT_NAME for example)
Leave a comment
June 24, 2013 by Kenneth Fisher

What is a metadata function? According to BOL a metadata function is one that returns data about the database or …
Continue reading

Category: Microsoft SQL Server, SQLServerPedia Syndication, System Functions and Stored Procedures, T-SQL | Tags: code language, language sql, microsoft sql server, sql statements, system functions, T-SQL
Disaster Recovery’s big brother Operational Recovery
15
June 20, 2013 by Kenneth Fisher

I’m going to get slammed for the title by someone but I stand by it. First some definitions. Disaster Recovery …
Continue reading

Category: Backups, Microsoft SQL Server, SQLServerPedia Syndication | Tags: backup strategy, backups, microsoft sql server, recovery strategy
ORDER BY the numbers
17
June 17, 2013 by Kenneth Fisher

Have you ever needed to order by a calculated column? You might have written it something like this: Did you …
Continue reading

Category: Microsoft SQL Server, SQLServerPedia Syndication, T-SQL | Tags: code language, language sql, microsoft sql server, sql statements, T-SQL
Best practice recommendations for writing Dynamic SQL
16
June 12, 2013 by Kenneth Fisher

Note this is not “Best Practices when USING Dynamic SQL”. These are just good habits I’ve come up with over …
Continue reading

Category: Dynamic SQL, Microsoft SQL Server, SQLServerPedia Syndication, T-SQL | Tags: best practices, code language, dynamic sql, language sql, microsoft sql server, sql statements, T-SQL
Using the OVER clause
2
June 10, 2013 by Kenneth Fisher

Over the last few years I’ve learned quite a bit about different techniques in SQL Server. This particular one has …
Continue reading

Category: Microsoft SQL Server, SQLServerPedia Syndication, T-SQL | Tags: code language, language sql, microsoft sql server, sql statements, T-SQL
Pattern searches beyond ‘%string%’.
4
June 3, 2013 by Kenneth Fisher

I was asked today to take a table with a social security column and put all 0s if the column …
Continue reading

Category: Microsoft SQL Server, SQLServerPedia Syndication, T-SQL | Tags: code language, language sql, microsoft sql server, sql statements, T-SQL
Backup a password, change it, then restore it.
3
May 30, 2013 by Kenneth Fisher

A couple of months ago I talked about moving a login from one server to another without the password. The …
Continue reading

Category: Dynamic SQL, Microsoft SQL Server, Security, SQLServerPedia Syndication, T-SQL | Tags: code language, dynamic sql, language sql, microsoft sql server, security, sql statements, T-SQL

« Older Entries

Newer Entries »

SQL Studies

Tag Archives: microsoft sql server

Ordering steps in a SQL Agent job

Writing Dynamic SQL (A how to)

Using OUTPUT to back up a change

Metadata Functions (OBJECT_NAME for example)

Disaster Recovery’s big brother Operational Recovery

ORDER BY the numbers

Best practice recommendations for writing Dynamic SQL

Using the OVER clause

Pattern searches beyond ‘%string%’.

Backup a password, change it, then restore it.

Follow me via RSS

Follow me via Email

Follow me on Twitter

Archives

Categories

Meta