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
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,090 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
Blogs
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...
Monday Monitor Tips: Configuring Access to the MCP Server
By Steve Jones
I have been experimenting with MCP servers in a few ways, including the Redgate...
The GO Barrier: Why SSMS Multi-Server Query Waits for the Slowest Connection
By Zikato
I deployed a schema change to 30 servers using multi-server query and deploy-at-low-priority. Small...
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