Sparklines and Conditional Formating in SSRS
When creating a SSRS report, you want to add lines that display trends. You want to show trends for more...
2013-02-26
869 reads
Restart the SQL Server Agent Service using PowerShell
Just a quick one today chaps, to show how you can restart the SQL Server Agent Service using PowerShell.
Whilst covering...
2013-02-26
5,086 reads
SQL Server Videos
About two weeks ago, I wrote about SQL Server Podcasts and why I love that medium so much.
Today, I want...
2013-02-26
1,059 reads
Data Warehouse Architecture Presentation
I will be presenting the session “Data Warehouse Architecture” this Wednesday, Feb 27th at 11:00am CST to the PASS DBA virtual...
2013-02-26
950 reads
A Rickety Stairway to SQL Server Data Mining, Algorithm 9: Time Series
by Steve Bolton
The data mining method known as Time Series is aptly named, because it seems to take a...
2013-02-26
3,131 reads
SQL Server features that are not supported by Azure SQL Database
SQL Server is in the Cloud as Windows Azure SQL Database, but in the Cloud, still have some limitations that...
2013-02-26
6,813 reads
70-461 Test SQL Ranking Functions
I created a post-webinar SQL Ranking Functions interactive test which relates to 70-461 Exam and thought I will share it....
2013-02-25
1,844 reads
Webcast “Performance Impacts of User Defined Functions” This Week with Pragmatic Works
Functions might seem to be the answer to all of your desires to consolidate code, and at times they could...
2013-02-25
657 reads
SQL Server Discovery Report
How can I check what all SQL server features and version are installed on my Machine ?
It’s a frequently asked...
2013-02-25
1,571 reads
A Learning Experiment at SQL Saturday #187– Richmond
In a little over a week, SQL Saturday #187 takes place in Richmond, VA. I’m looking forward to going back...
2013-02-27 (first published: 2013-02-25)
1,152 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
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...
Negative and Positive Numbers
Comments posted to this topic are about the item Negative and Positive Numbers
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