Correlated Datetime Columns
SQL Server is a deep and complex product. There’s always more to learn. For example, I had never heard of...
2016-10-13 (first published: 2016-10-03)
1,811 reads
Blog Posts
In-memory tables in 60 seconds
As a SQL Server DBA or developer here is what you should know about memory-optimizedtables (in-memory tables):
Introduced in SQL Server 2014Primary...
2016-10-13
302 reads
In-memory tables in 60 seconds
As a SQL Server DBA or developer here is what you should know about memory-optimized tables (in-memory tables):
Introduced in SQL Server 2014
Primary store is main memory, second copy maintained on...
2016-10-13
8 reads
Microsoft Certifications
Every now and again I would navigate to Microsoft’s certification page and see what / if any changes have taken place...
2016-10-13
534 reads
MS Access – Store a Different Value than Displayed in a Combo Box
It is occasionally usefully to display a different values in an Access combo box than what is actually stored in...
2016-10-13
459 reads
My thoughts on Recertifying your MCSE through Microsoft Virtual Academy
A couple of years back I achieved the Microsoft certification MCSE – Business Intelligence. You can read all about that process in...
2016-10-13
788 reads
Query shortcuts in SQL Server Management Studio
Tired of typing out the same queries day after day? Well query shortcuts in SSMS are for you!
Following on from...
2016-10-13 (first published: 2016-09-28)
4,132 reads
Too many indexes!
Indexes are great. They speed up our queries. In fact, without them relational database systems wouldn’t work.
Different indexes work best...
2016-10-13
589 reads
Why I Practice Presentations
I had a new presentation to give this week at IT/DevConnections. This is a paid for conference, and I want...
2016-10-13
851 reads
You don't need any Training? OK...I believe you.
This week's Super duper IT training offers are in:
If you see any that take your fancy let me know. Drop...
2016-10-13
441 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