PASS Summit 2001 In Review…WOW!!!
It has been a couple of weeks and I have had time to get back in the groove at a...
2011-10-28
1,706 reads
SQL Server Analysis Services Performance Guide published
Another must read white-paper: Analysis Services 2008 R2 Performance Guide.
This white paper describes how business intelligence developers can apply query...
2011-10-28
2,525 reads
Displaying blank sub report
Recently I had to convert a stand alone report into a sub-report. That report was very simple… it had two...
2011-10-28
1,048 reads
Play the Bob Ross Game
I was in a meeting a few weeks ago, deadlines looming and everyone feeling the stress some. We hit a...
2011-10-28
801 reads
Convert comma separated string to table and vice versa
I know that this subject has been blogged about numerous times but I thought I'd post an alternative way of...
2011-10-28
9,412 reads
I/O Error On TempDB
I was running a DBCC CHECKDB on a database when I got an error that says:
Msg 0, Level 11, State...
2011-10-28
1,996 reads
Webinar on SQL Server Security on November 3, 2011
I have the privilege of being able to give a webinar next Thursday, November 3, at 11 AM EDT. It...
2011-10-28
1,011 reads
Save a step: Using Computed Columns in a Table Variable (or Temp Table)
One of the databases that I support reports all money values in both the local currency and US Dollars. Very...
2011-10-28
15,201 reads
Understanding Kerberos, Part III
Welcome back to both our Kerberos coverage and to another topic for SQL University's Security and Auditing Week. In today's...
2011-10-28
16,749 reads
A Thought on Career Decisions
One of the many conversations I had at the PASS Summit was about whether to pursue Direction A or Direction...
2011-10-28
646 reads
Blogs
Creating a Local Model Chatbot on Windows
By Steve Jones
After my session at VSLive last week, I had a few questions from the...
To refer and to be referred
Referrals have never been more important in the job market. They’re no longer nice...
A New Word: Dorgone
By Steve Jones
dorgone– adj. wondering if you could slip away from an event or group conversation...
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