Building My Next Workstation–Part 2
Building a computer, at least in the beginning, feels like something you have to do holistically and at the same...
2013-02-25
1,263 reads
SQL BLOG: Calculating total number of days from 1st Jan without using DATEDIFF function
Below script will calculate total number of days based on the input from user from 1st Jan. Though we have...
2013-02-25
884 reads
Managing Critical Server Lists with Remote Desktop Connection Manager
Most Server Administrators, whether Database Administrators or not, are quite familiar with the Remote Desktop Connection (a.k.a. RDP) tool, which...
2013-02-25
2,622 reads
Day 29 of 31 Days of Disaster Recovery: Using Database Snapshots to Restore Replicated Databases in Test
For day 29 of my 31 Days of Disaster Recover series, I want to talk about restoring replicated databases from...
2013-02-25
1,365 reads
PerformancePoint ‘Named Set’ Filter
PerformancePoint provides several options to create filters. One of the options available is ‘Named Set’. Within SSAS cubes we can...
2013-03-01 (first published: 2013-02-25)
2,122 reads
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
573 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
735 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,191 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
440 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,126 reads
Blogs
New article – migrating from a named instance
By Brian Kelley
Do you have a case where you have a named instance you'd like to...
Using the SIGN() Function: #SQLNewBlogger
By Steve Jones
I was trolling the docs and noticed the SIGN() function. I have never written...
T-SQL Tuesday #201 Round-Up: Temp Tables, Friend or Foe?
By ReviewMyDB
The T-SQL Tuesday #201 round-up: nine bloggers on whether temp tables are a friend...
Forums
Admin Rights for Everyone
Comments posted to this topic are about the item Admin Rights for Everyone
Kerberos Authentication for Aurora PostgreSQL: Mapping AD Groups to Database Roles
Comments posted to this topic are about the item Kerberos Authentication for Aurora PostgreSQL:...
RegEx Functions I
Comments posted to this topic are about the item RegEx Functions I
Question of the Day
RegEx Functions I
Which of these RegEx functions need compatibility level 170 in SQL Server 2025?
See possible answers