TSQL Tuesday #93: 2 Job Interviews
T-SQL Tuesday #93
I decided to join the T-SQL Tuesday blog series that Kendra Little is leading this month, on the...
2017-08-08
572 reads
Blog Posts
T-SQL Tuesday #93: 3 Jobs I Didn’t Take and 1 I did
It’s T-SQL Tuesday again, and this month’s host is Kendra Little (blog|@), and the excellent topic selected by Kendra is...
2017-08-08
602 reads
T-SQL Tuesday #93–Interviewing Patterns
It’s time for T-SQL Tuesday, and this is a good topic. Not too close to T-SQL, but certainly something many...
2017-08-08
450 reads
Why Parameter Sniffing Isn't Always A Bad Thing (But Usually Is)
In this series I explore scenarios that hurt SQL Server performance and show you how to avoid them. Pulled from my collection of "things I didn't know I was...
2017-08-08
19 reads
Azure Cloud “Fear” Busting #2 – Seeking for Better Performance
We all want high performing applications and when you are in the cloud that is no different, if anything it...
2017-08-07 (first published: 2017-07-20)
1,381 reads
Azure Cloud “Fear” Busting #3 – There is no going back?
Once you go cloud, there is no going back. This is false and from a database perspective you can migrate...
2017-08-07
441 reads
Database Fundamentals #7: Create a Table Using T-SQL
The syntax for creating a table logically follows many of the same steps that you did when using the GUI,...
2017-08-07
296 reads
Database Fundamentals #7: Create a Table Using T-SQL
The syntax for creating a table logically follows many of the same steps that you did when using the GUI,...
2017-08-07
189 reads
Dataedo - First Look
update 2019-02-22
Image links broken. Since their product is continually improving, I'm going to just link to their product here instead so you can review their latest demo content there....
2017-08-07
16 reads
Dataedo - First Look
Diagraming and Documentation
Previously, I've written up on database diagramming for visualization of database structures. Check that out for more detailed...
2017-08-07
750 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