SQL BLOG: Calculating number of week along the days completed in that week for a given input date
Below code will display the week started along with the number of days completed in that week. For deriving this...
2013-02-24
579 reads
PASS Data Arch VC presents: Neil Hambly’s Think You Have The Right Data-Type?
Please join this Thursday Feb 24th 2013 at noon central for Confio SQL Server expert Neil Hambly talking SQL Server...
2013-02-24
736 reads
A Month of PowerShell – Day 24 (JobServer: Jobs)
Welcome to Day 24 of my “A Month of PowerShell” series. This series will use the series landing page on...
2013-02-24
2,192 reads
SQL BLOG: Playing with Date Time
Below code returns remaining days in the month based on the input date. We can have this inside a function...
2013-02-24
448 reads
A Month of PowerShell – Day 23 (JobServer: Alerts)
Welcome to Day 23 of my “A Month of PowerShell” series. This series will use the series landing page on...
2013-02-23
2,128 reads
SQL Server Encryption
Today, I am very happy because my first article (SQL Server Encryption) was published in SQL Server Pro. In this...
2013-02-23
1,091 reads
The pros and cons of virtualizing SQL Server environments
Virtualization is a hot trend in the computing world, offering businesses substantial cost and performance benefits that include server consolidation,...
2013-02-23
1,606 reads
XML Support and SQL Server (Part 4)
Checkout the fourth part of my XML support and SQL Server article series here.
In this part, I talked about XML...
2013-02-23
845 reads
Partitioning Relational Data – (Part – 3)
This is the third part of the three part article series on partitioning relational data.
In the first part of this...
2013-02-23
574 reads
Search all running SQL Server instances over LAN
Sometimes you need to know how many and what instances of
SQL Server running in your organization over Network. You can...
2013-02-22
2,373 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