Lost in Translation – Deprecated System Tables – sysusers
This post is part of a blog series which focuses on translating compatibility views in SQL Server to their respective...
2012-11-21
1,779 reads
Most Interesting People…
Here are the most interesting people I met at PASS Summit 2012 Mickey Stuewe (sqlmickey) Neil Hambly (neil_hambly) Bob Hovious Gail Shaw (sqlinthewild) Ed Watson (SQLGator) ...
2012-11-21
11 reads
Most Interesting People…
Here are the most interesting people I met at PASS Summit 2012
Mickey Stuewe (sqlmickey)
Neil Hambly (neil_hambly)
Bob Hovious
Gail Shaw (sqlinthewild)
Ed Watson...
2012-11-21
1,443 reads
How to Use xp_delete_file to Purge Old Backup Files
Continuing on my recent trend of using undocumented stored procedures, this week I thought we can cover using xp_delete_file to...
2012-11-21
4,441 reads
Lost in Translation – Deprecated System Tables – syspermissions
This post is part of a blog series which focuses on translating compatibility views in SQL Server to their respective...
2012-11-21
1,109 reads
Final 2012 Learning Opportunity
There’s still a little time left in the year. I know some businesses have allocated training budgets and if they...
2012-11-21
1,116 reads
Top 3 Books on Writing Transact-SQL (TSQL)
This weeks blog posts have been focusing on books that I have read, like and recommend for learning SQL Server...
2012-11-21
967 reads
blogging fun: dealing with spammers like Psychz Networks
@PsychzNetworks is spamming me non-stop. Every minute of every day.
I googled them and it seems Psychz Networks are famous for...
2012-11-21
1,510 reads
PASS Summit 2012 Recordings Available
Did you attend PASS Summit and miss out on some sessions because there were so many or you were busy...
2012-11-21
1,253 reads
CTEs beyond SELECT
The other day I was writing a query to pull some DMV information and I ended up using several CTEs...
2012-11-20
1,987 reads
Blogs
Don’t Fear the Technology
By Brian Kelley
The concern that a particular technology is going to destroy the world seems to...
Creating a Custom SQL Server Security Checklist Using the DoD STIG
The STIG is detailed, which is a good thing, but I found myself wanting...
Creating a Local Model Chatbot on Windows
By Steve Jones
After my session at VSLive last week, I had a few questions from the...
Forums
Querying Multiple Tables for the Same Information
I have about 100 Tables that are all suffixed with _Modify. These tables record...
Make It Routine
Comments posted to this topic are about the item Make It Routine
Finding Gaps in Sequential Data Using SQL Server
Comments posted to this topic are about the item Finding Gaps in Sequential Data...
Question of the Day
Negative and Positive Numbers
If I want to know whether a number of negative, positive, or zero, what is the easiest way to get this in T-SQL?
See possible answers