Unlocking “Lock Pages in Memory” Option
Consider this scenario; Your production database server is new and with super configuration of 32 CPUs, 64G RAM, SAN Storage,...
2013-07-08
346 reads
SQL Server Quickie #6 – THREADPOOL Starvation
(Be sure to checkout the SQLpassion Online Academy, where you get High-Quality SQL Server Trainings with Instant Access!)
Today I have...
2013-07-07
1,552 reads
Ready, Set, Go! Upcoming Speaking Events
Huge sandwich from recent trip to downtown Chicago
First, I want to acknowledge that I’ve been pretty quiet on here lately....
2013-07-07
735 reads
So how was your weekend?
It’s Sunday night now, weekend is almost over and was it just a few moments ago that it was Friday?...
2013-07-07
329 reads
Installing Microsoft Hyper-V 2012 on VMware ESXi 5.1
For a weekend project, I’m installing Hyper-V 2012 in my home lab. I was having troubles getting Hyper-V installed on...
2013-07-06
894 reads
SQLCMD –Quick Copy of Files – Using Robocopy
The requirement is to move the files to different server programatically and hence I’ve decided to use Robocopy in SQLCMD.
Robocopy...
2013-07-05
1,993 reads
Try out SQL Server 2014 CTP1 on Windows Azure
When SQL Server 2014 CTP 1 was announced last week, I was on it and getting ready to download within a...
2013-07-05
1,159 reads
Reblog: June 28 to July 4
I’ve always been a fan of the feeling when I find an old blog post that’s got just the information...
2013-07-05
414 reads
Maidenhead SQL Server User Group – 9th July with Alex Whittles and John Martin
Another month and another evening of top quality free SQL Server goodness for those living/working in the Maidenhead area of...
2013-07-05
700 reads
SQL Saturday Orlando: LAST CALL for Speakers
Hello Dear Reader! I just wanted to write to Thank All of you for the submissions to SQL Saturday 232...
2013-07-05
766 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...
Cleaning Up My Blog's SEO and AEO with Claude in GitHub Copilot
I’ve been running this blog on Hugo for a long time, and like most...
Using the SIGN() Function: #SQLNewBlogger
By Steve Jones
I was trolling the docs and noticed the SIGN() function. I have never written...
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