Mixed page allocation
MIXED_PAGE_ALLOCATION is a new option introduced with SQL Server 2016. It controls whether the database can create initial pages using...
2017-04-08
5,824 reads
Testing SQL Server Access to a share with PowerShell using dbatools
A good security practice is to backup our SQL Servers to a network share but not allow users to be...
2017-04-13 (first published: 2017-04-08)
1,386 reads
PASS Cloud Virtual Group – Call for Speakers
The cloud is calling to you. Or more specifically, Jody Roberts (b | @) and I (b | @) are looking to the community to find some presenters interested in...
2017-04-07
20 reads
PASS Cloud Virtual Group – Call for Speakers
The cloud is calling to you. Or more specifically, Jody Roberts (b | @) and I (b | @) are looking to the community...
2017-04-07
954 reads
Who Left Those Old Components in My New Database???
Recently a client requested some new transactional replication publications on a relatively new pre-production server. The client has plenty of...
2017-04-13 (first published: 2017-04-07)
2,314 reads
Testing the Identity Column usage in SQL Server with PowerShell and dbatools
SQL Server uses identity columns to auto generate values, normally keys. When you create an identity column, it has a...
2017-04-07
565 reads
Speaking at SQL Saturday #621–Silicon Valley
Once again I’m heading back to the Valley. I was accepted to speak at SQL Saturday #621 – Silicon Valley on...
2017-04-07
641 reads
Friday Reading 2017-04-07
As this is being published I’m on my way up to Dublin airport to head on over to the UK...
2017-04-07
148 reads
Friday Reading 2017-04-07
As this is being published I’m on my way up to Dublin airport to head on over to the UK...
2017-04-07
346 reads
UK Contracting: Brexit, Dividend Tax and IR35 Having a Huge Impact
At the end of March I wrote a couple of posts discussing the state of IT industry. It looked at...
2017-04-07
300 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