Self Hosting WCF Services With Transport Security
When developing and debugging transport security WCF services it’s a real pain if each developer on the team needs to...
2013-03-15
207 reads
Renaming Server with SQL
I recently had to rename my laptop on which I have two SQL server instances. I have a default instance...
2013-03-14
1,688 reads
The STUFF function
While I was at the 2011 Pass Summit I was given the following piece of code to create a comma...
2013-03-14
906 reads
Customizing SSMS – Hiding the panels
This is a short series on some customizations in SSMS to make it visually more appealing.
As a presenter, I’ve learned...
2013-03-14
1,160 reads
SQL Server : Part 4 :Explaining the Non Clustered Index Structure
A table can have only one clustered index as the data rows are stored in the order of the clustered...
2013-03-14
30,629 reads
Logging into Azure and Office365 with Different Accounts
I have been doing some work on the Modern Apps Live! content that required me to use both an Office365...
2013-03-14
796 reads
Why you need Business Intelligence
First lets define what Business Intelligence (BI) is. My favorite definitions:
Forrester Research: “Business Intelligence is a set of methodologies, processes,...
2013-03-14
2,060 reads
Index Tuning
This week I've been carrying out some performance tuning of some of the more intensive procedures in one of our environments. Using...
2013-03-21 (first published: 2013-03-14)
3,631 reads
SQL Server under source control with Team Foundation Services and Red-Gate Source Control
During the last few years I’ve been involved in database source control management and release plans tasks. These are important...
2013-03-14
783 reads
PowerShell Usage in DBA Work — Case Study 3/7
As a DBA, sometimes we may need to demonstrate to some stakeholders when a sql server instance was last rebooted,...
2013-03-14
1,183 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