SQL Saturday 220 Atlanta GA
That latest installment of SQL Saturday Atlanta was just announced. On May 18th 2013 SQL Server experts from all over...
2013-02-04
638 reads
Exploring Excel 2013 as Microsoft’s Business Intelligence Client
A little over six months ago, I wrote an article on Magenic.com about Excel 2013’s Impact for BI Users. This...
2013-02-04
1,409 reads
A Month of PowerShell – Day 4 (Scripting)
Welcome to Day 4 of my “A Month of PowerShell” series. This series will use the series landing page on...
2013-02-04
1,001 reads
Adding the Clustered Key To Your Nonclustered Index?
A colleague of mine was understandably confused when using the almost-perfect missing index engine in SQL 2008. The engine recommended he include...
2013-02-04
697 reads
New DMO in Azure SQL Database: sys.dm_db_wait_stats
I just did a series of Boogle searches and when that didn’t find anything I tried Ging. Neither listed sys.dm_db_wait_stats....
2013-02-04
1,406 reads
I hate Windows 8 and Microsoft Top 3 Mistakes
What do you think about Microsoft new Operating System? I hate Windows 8! This is the answer that many people...
2013-02-04
1,010 reads
Duplicate rows in a table
I recently got the following email:
“I just keyed in two rows into a table with all identical column values. How...
2013-02-11 (first published: 2013-02-04)
3,276 reads
Where Should Database Administration Go?
For the past 5 or 6 years, we have seen lots of innovative products emerged, from smartphone to tablets, from...
2013-02-04
790 reads
SQL Server Analysis Services Tabular KPIs
A few weeks ago, I wrote a blog post that discusses implementing KPIs in SQL Server Analysis Services Multidimensional. For...
2013-02-04
2,628 reads
SQLSaturday #184 in New Haven, CT - March 2, 2013
So much SQL, and so little Saturdays. SQLSaturday is truly a world-class event
happening all over the globe. Just this
past Saturday,...
2013-02-04
1,254 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