Deploy an SSIS project to the SSIS catalog.
You’ve installed SSDT, created an SSIS project, created any packages you need and now you want to place that project...
2017-08-21
847 reads
Blog Posts
Microsoft Azure – How to Check the availability of cloud services using PowerShell
Hello friends, in this blog we will learn how to check whether a cloud service is available to use with...
2017-08-21
477 reads
Monday Coffee: Posting error messages
I posted a couple of messages on twitter over the weekend giving any new bloggers advice that was given to...
2017-08-21
292 reads
New eBook with Pure Storage – Overcoming SQL Server Storage Challenges
My company, Heraflux Technologies, is proud to announce a new ebook as part of our joint partnership with Pure Storage!...
2017-08-21
246 reads
New Whitepaper – Capture Production Error States
System administrators of the world, if a VM experiences a problem that takes down business-critical application, your job is to...
2017-08-21
120 reads
New Whitepaper – Capture Production Error States
System administrators of the world, if a VM experiences a problem that takes down business-critical application, your job is to...
2017-08-21
303 reads
Start Your Engine’s with Startup Procedures
After reviewing some recent audit results for a couple of our SQL Servers, I noted the audit checked for start up...
2017-08-21 (first published: 2017-07-31)
1,867 reads
Training and tips to get certified with Microsoft (Part 4 and last)
In the previous posts I posted some questions that I usually get when we talk about getting certified with SQL Server also listed some resources you can use to...
2017-08-21
11 reads
Training and tips to get certified with Microsoft (Part 4 and last)
In the previous posts I posted some questions that I usually get when we talk about getting certified with SQL...
2017-08-21
140 reads
Database Issue: The transaction log for database ‘db_name’ is full due to ‘ACTIVE_BACKUP_OR_RESTORE’.
Today, I was called in the early hours because the transaction log of one of the SQL Server 2016 database was full. I logged onto the SQL server instance...
2017-08-20
39 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