PowerSQL – SQL Instance Configuration & Installation Information by Reading Registry Keys
Today I got a chance to retrieve configuration information of sql server 2005 instances. PowerShell provide a facility to read...
2013-07-02
1,138 reads
SSRS export to Excel converts DateTime Column to Text Column
Recently we observed a weird issue with SSRS export to Excel. One of the datetime column in the report was...
2013-07-02
1,902 reads
SQL Database connectivity|| SharePoint Configuration || Named Pipes Error In MOSS 2007
Hello Friends,
MOSS2007 is still live and sometime we need to check certain features and that can give learning too. Recently...
2013-07-02
985 reads
SQL Server: Part 3 : All About SQL Server Statistics :Who Create and Manage the Statistics ? Role of Statistics in Performance Tuning
In the last posts, we have discussed about the histogram ,density vector and how SQL server use the statistics information in cardinality estimation. In this post let us discuss about how the...
2013-07-02
149 reads
Monitoring Memory Usage of Memory Optimized Objects – SQL Server 2014
Starting SQL 2014 monitoring memory usage of the memory optimized objects is super important to ensure that your instance don’t...
2013-07-01
1,498 reads
SQL Server: Part 3 : All About SQL Server Statistics :Who Create and Manage the Statistics ? Role of Statistics in Performance Tuning
In the last posts, we have discussed about the histogram ,density vector and how SQL server use the statistics information...
2013-07-01
1,526 reads
Writing Dynamic SQL (A how to)
A little while back I wrote Best practice recommendations for writing Dynamic SQL where I made a number of suggestions...
2013-07-01
2,742 reads
July 2013 – Monthly SQL Server Checklist
First Monday of the month and time to update the monthly SQL Server checklist. Monthly SQL Server checklist, you ask?...
2013-07-01
917 reads
Getting Started With SQL Server 2014 the Easy Way
You know you want to at least take a look at the new Client Technology Preview (CTP) of SQL Server...
2013-07-05 (first published: 2013-07-01)
2,160 reads
Last Weeks Top “Reading” Links #39
For those that follow me on twitter (@StrateSQL), you’ll know that throughout the day I tweet out some links of...
2013-07-01
485 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