Tag Archives: microsoft sql server
-
Questions from “SQL Server Security for Everyone”
2November 4, 2015 by Kenneth Fisher
I recently gave my SQL Server Security for Everyone session at Summit 2015. (I’m still in awe about that by …
Continue reading -
Finding and keeping your #SQLPassion
1October 26, 2015 by Kenneth Fisher
I consider myself lucky. I fell into a job that I truly enjoy, something that I do for fun even …
Continue reading -
Generating scripts for previous versions of SQL
1October 21, 2015 by Kenneth Fisher
I make a habit of using the latest version of SSMS even if I’m not working with the latest version …
Continue reading -
Working with “special” names
4October 19, 2015 by Kenneth Fisher
What do you do when you need to use a special character in a name? Well, I guess I should …
Continue reading -
“That little green arrow.” or “My code used to work but now I’m getting a debug error.”
3October 15, 2015 by Kenneth Fisher
If you’ve worked with SSMS for any length of time this will look awfully familiar: SSMS 2008R2 SSMS 2012 + …
Continue reading -
Keep an eye on those Audit files!
1October 13, 2015 by Kenneth Fisher
This month’s T-SQL Tuesday (#71) is hosted by Sebastian Meine (b/t). He has picked an interesting security subject. SQL Server …
Continue reading -
Finding the error from a failed job.
5October 7, 2015 by Kenneth Fisher
This is a fairly simple one once you’ve seen it, but then so are lots of things :). Let’s say …
Continue reading -
Updating a view
2September 30, 2015 by Kenneth Fisher
I was recently asked how to update views. Specifically the question was about using triggers to update a view. So …
Continue reading -
SSMS Connection Information
Leave a commentSeptember 28, 2015 by Kenneth Fisher
If you work with a number of different instances and have lots of connections open in Management Studio (SSMS) it …
Continue reading
SQL Studies 