Using Merge–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2017-08-14
980 reads
Blog Posts
Working with Very Large Tables
Recently I presented an online session with the title “Working with Very Large Tables Like a Pro in SQL Server 2016”....
2017-08-14 (first published: 2017-07-26)
4,745 reads
PSDay.UK Tickets are on sale
Following a lot of hard work by the organising folks Gael Colas, Ebru Cucen, Daniel Krebs and Johnathan Medd, we...
2017-08-13
352 reads
Building Your Brand and Becoming a Thought Leader Session Materials
Thank you to everyone that attending my session today at SQL Saturday #649 in Jacksonville, Florida! It was a packed...
2017-08-12
589 reads
DevOps Basics–Git log
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2017-08-11 (first published: 2017-07-19)
1,809 reads
Just Say No to Social Engineering Memes
These memes, from a security and privacy perspective, are nothing but trouble. Here’s an example I just saw a friend...
2017-08-11
1,446 reads
Microsoft Azure – How to create a virtual machine (VM) with Reserved Public IP (VIP)
In my previous blog, we learnt that a Virtual IP (VIP) get lost or changed when we stop or deallocate...
2017-08-11
689 reads
Performance is bad. Did you change anything recently? No. Are you sure?
Ever have this conversation?
Dev: Hey, can you help me? The performance on my application is terrible all of a sudden.
DBA:...
2017-08-11 (first published: 2017-07-26)
3,203 reads
SQL Server vs Oracle: Convert string to date
Over this week we’ve looked at the difference between Oracle and SQL Server from a few different angles. We’ve looked...
2017-08-11
1,261 reads
SQLskills is Giving Away Free Training!
SQLskills is giving away free training for their performance tuning and optimization classes. My entry for the competition is below. If you decide to enter for yourself, entries are...
2017-08-11
13 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