What Limits Do You Want in 2019?
With SQL Server 2019 getting closer to release, Steve asks about the hardware limitations that we should have in Standard Edition.
2019-05-20
1,502 reads
SQL Server 2019
2019-04-27
175 reads
Parameter Sniffing in SQL Server 2019: Adaptive Memory Grants
This week, Brent is demoing SQL Server 2019 features that he's really excited about, and they all center around a theme we all know and love: parameter sniffing.
2019-04-26
Why should SQL Server 2019 excite developers?
Phil Factor is excited for SQL Server 2019 and is keen to tell you why.
2019-04-06
698 reads
New Page Functions in SQL Server 2019
Two new tools will be making an appearance in SQL Server 2019, a dynamic management function (DMF) and the other a function, will be making an appearance, namely sys.dm_db_page_info and sys.fn_pagerescracker respectively.
2019-04-05
SQL Server 2019 Adds CosmosDB Support
SQL Server 2019 will bring more than graph query languages. We will be able to use a document query engine and a specific JSON engine.
2019-04-01
3,255 reads
SQL Server 2019 Community Technical Preview (CTP) 2.1 is Available Now
Microsoft announced the release or CTP 2.1 for SQL Server 2019. This is the second CTP released for SQL Server 2019, and it has lots of new exciting features, like " UDF inlining". Read on to find out more!
2018-12-25
2,797 reads
2018-12-20
14,631 reads
There is a New COUNT in Town
Now that SQL Server 2019 is on the way, it’s time to start learning about the new capabilities. In this article, Greg Larson tests the new APPROX_COUNT_DISTINCT function for performance and accuracy.
2018-12-13
4,741 reads
SQL Server 2019 Community Technical Preview (CTP) 2.1 is Available Now
Microsoft announced the release or CTP 2.1 for SQL Server 2019. This is the second CTP released for SQL Server 2019, and it has lots of new exciting features, like " UDF inlining". Read on to find out more!
2018-12-11
2,386 reads
Blogs
A New Word: Dorgone
By Steve Jones
dorgone– adj. wondering if you could slip away from an event or group conversation...
Tell It Once: Setting Up Claude With Skills and MCP Servers
By ReviewMyDB
Many of us use AI the same way every single day. Open a tab....
SQL Server Transaction Log Forensics: Preserving Evidence During an Incident
By SQLPals
SQL Server Transaction Log Forensics: Preserving Evidence During an Incident SQL...
Forums
Make It Routine
Comments posted to this topic are about the item Make It Routine
Finding Gaps in Sequential Data Using SQL Server
Comments posted to this topic are about the item Finding Gaps in Sequential Data...
Negative and Positive Numbers
Comments posted to this topic are about the item Negative and Positive Numbers
Question of the Day
Negative and Positive Numbers
If I want to know whether a number of negative, positive, or zero, what is the easiest way to get this in T-SQL?
See possible answers