Monday Coffee – Lab Environments
Having a lab environment is an absolute must for any IT professional. You need somewhere that you can test out...
2017-06-05
283 reads
Blog Posts
Setting up the Power BI Report Server Preview
Last week on May 17th the Power BI team announced the release of the Power BI Report Server preview. Power...
2017-06-05 (first published: 2017-05-23)
3,110 reads
SQL Server – Service Terminated
I had a messy (another one) day, last thing I wanted was a “broken” SQL Server instance where I was...
2017-06-05
410 reads
SQL Server Application Roles
If you’re using Windows Authentication then you probably have a database user for each user of your application or at...
2017-06-05
199 reads
SQL Server Monitoring: Creating your own metrics
The one and only important factor in monitoring is data. How much of x and how little of y? If...
2017-06-05
582 reads
SQLSat Pcola 2017 Security Principals and Permissions
Great attendance and awesome questions from my afternoon session on "SQL Security Principals and Permissions". As promised, both the demo...
2017-06-05
277 reads
SQLSaturday Orlando 2017 Goes Live
Today we’re starting on our 11th SQLSaturday here in Orlando. Normally we rotate the leadership between oPASS and MagicPASS, but...
2017-06-05
510 reads
Top Function – Performance Gain
Recently, I presented at Singapore SQL Pass Chapter on the topic T-SQL Fun, and the most of the attendees were...
2017-06-05
484 reads
VSTS– Hosted Agent is the Default for Releases
In keeping with the idea I don’t want this to get out of date, this is VSTS as of Jun...
2017-06-05
613 reads
SQL Graph, part I
This blog is a kick-off the series that will be dedicated to the graph databases and engines, being more specifically...
2017-06-03
1,225 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