SQL Server
What is SQL Server?Microsoft SQL Server is Relational database management system (RDBMS) developed and owned by Microsoft. It is a software...
2013-01-28
437 reads
Granting Permission to Grant Permissions
I’ve never felt the need to allow this, but I saw someone ask the questions recently. Suppose you had a...
2013-02-08 (first published: 2013-01-28)
2,571 reads
"Auto update statistics" option on tempdb
"Auto update statistics" option is enabled by default on tempdb, if it is disabled, you may get trouble in some...
2013-01-28
2,930 reads
New Year Aspirations – Annette Allen – WiT
Thanks for agreeing to do this Annette, with your SQL Saturday event only a few weeks away thing must be...
2013-01-28
938 reads
Last Weeks Top 10 “Reading” Links #17
Throughout the week, I like to tweet links to the things that I’ve been reading. Since they all come out through out...
2013-01-28
974 reads
Changes
Last month I mentioned that I’d like to start including Oracle stuff on this blog. I’m getting back into that...
2013-01-28
707 reads
I’ll Meet You Half Way–Compromising To Win
Compromise is one of those things that makes the world work. I can’t say I’ve always been good at it....
2013-01-28
783 reads
Model database
Most DBAs have at least some idea what the system databases are for. Master has the list of databases & logins,...
2013-01-28
949 reads
SSIS 6 Million Rows in 60 Seconds using standard laptop
SSIS is a very powerful tool and can be very fast however I frequently come across situations where performance could...
2013-02-01 (first published: 2013-01-28)
5,162 reads
How to find and install common IFilters||For Search||Crawl
Friends, As covered in one of my previous blog:
How crawl works in SharePoint ||How indexing work||Basic concept .
We were...
2013-01-28
1,260 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