Using Time Zones in SQL Server
The usage of time zones in applications becomes inevitable, especially with the globalization of the applications. Reports need to be run in different time zones. Services have to consider...
2017-08-18
15 reads
Blog Posts
Analysis Services Series on SQLShack
Please visit SQLShack.com for new articles on many facets of SQL Server. I have been trying my best to document how to create SQL Server Analysis Service databases with...
2017-08-17
43 reads
Change RegisterAllProvidersIP setting on an existing Availability Group
Was working with a client who had an existing Availability Group, but did not have the RegisterAllProvidersIP setting enabled on...
2017-08-17 (first published: 2017-07-30)
21,576 reads
Countdown to Denver SQL Saturday: Register and Attend
My First Presentation was on Database Security. Those slides are still available for nostalgia sake 66 to 673 in N...
2017-08-17
167 reads
K-SSIS-ed
K-SSIS-ed - View any property or script in SSIS with a single click A cross platform re-imagined IDE and SSIS package viewer with one goal to allow a developer...
2017-08-17
9 reads
K-SSIS-ed
K-SSIS-ed - View any property or script in SSIS with a single click A cross platform re-imagined IDE and SSIS package...
2017-08-17
69 reads
K-SSIS-ed
K-SSIS-ed - View any property or script in SSIS with a single click A cross platform re-imagined IDE and SSIS package...
2017-08-17
93 reads
Power BI NFL Football Stats Comparisons and Analysis Report is now available!
For the past few years I’ve combined my love of professional football and analytics by releasing a series of Power...
2017-08-17 (first published: 2017-07-28)
3,500 reads
Session Resources for: Visual Design Tips for Power BI & SSRS 2016+
Yesterday I did a session for Idera’s Geek Sync series called “Visual Design Tips for Power BI & SSRS 2016+”. In...
2017-08-17
434 reads
Session Resources for: Visual Design Tips for Power BI & SSRS 2016+
Yesterday I did a session for Idera’s Geek Sync series called “Visual Design Tips for Power BI & SSRS 2016+”. In the session, I called out a bunch of...
2017-08-17
20 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