How to Change Suspect Mode to Normal Mode in SQL Server Database
If you are reading this, you are desperately looking for solutions to change suspect mode to normal mode. It also...
2019-01-07
231 reads
Profiler Is Dead, Long Live Extended Events
OK, so profiler isn’t actually dead, it has however been deprecated since 2012 and has had no new features since...
2019-01-07
662 reads
A Monumental Migration to SQL Server 2016 - Part 1
A bit over a year ago, I blogged about my experience migrating a test SQL Server instance from a VM to a physical machine with a little help from...
2019-01-07
16 reads
Creating my own Map Shapefiles for Power BI
(2019-Jan-06) In the past, I used to always rely on shapefiles crafted by others to create my map visualizations in...
2019-01-15 (first published: 2019-01-06)
6,794 reads
When does it make sense to hire a data science consulting company?
Going into 2019, data science and machine learning is all the hype. Organizations in every industry are starting to realize...
2019-01-06
62 reads
Last Week Reading (2019-01-06)
Good morning chaps! Bunch of news from data’s world freshly served. Press Introduction to Testing Your PowerShell Code with Pester...
2019-01-06
177 reads
Hello Cristian,
Hello Cristian,
Thank you for sharing the link and your contribution. The idea behind the article is to be able to upload any file while the server is been provisioned....
2019-01-06
20 reads
Short Circuiting Your Session
It isn't very often that one would consider a short circuit to be a desired outcome. In SQL Server we have a cool exception to that rule - Extended...
2019-01-05
22 reads
Short Circuiting Your Session
It isn’t very often that one would consider a short circuit to be a desired outcome. In SQL Server we...
2019-01-16 (first published: 2019-01-05)
2,071 reads
One tip for presenting: have a conversation
I like public speaking, but I haven’t always liked it. It started when I read Dale Carnegie’s book on public...
2019-01-05
44 reads
Blogs
Creating a Custom SQL Server Security Checklist Using the DoD STIG
The STIG is detailed, which is a good thing, but I found myself wanting...
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...
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