The free SQL to Excel Export tool
Earlier this month I released a new, free tool to export SQL Server query data to Excel files without needing Excel. It also installs stored procedures… Read More »The free SQL to Excel Export tool
Compatibility
Does SQL Server 2019 run on Ubuntu 18.04 LTS?
Edit from 19 March 2020: Since the release of CU 3, SQL Server 2019 is officially supported on Ubuntu 18.04, per this blog post. Original… Read More »Does SQL Server 2019 run on Ubuntu 18.04 LTS?
Proposed SQL Server defaults: disable priority boost
(This post was updated on 5 February 2022.) A few months ago I suggested that the following settings should be the default for most SQL… Read More »Proposed SQL Server defaults: disable priority boost
Proposed SQL Server defaults: disable lightweight pooling
(This post was updated on 5 February 2022.) A few months ago I suggested that the following settings should be the default for most SQL… Read More »Proposed SQL Server defaults: disable lightweight pooling
Proposed SQL Server defaults: cost threshold for parallelism
(This post was updated on 5 February 2022). A few months ago I suggested that the following settings should be the default for most SQL… Read More »Proposed SQL Server defaults: cost threshold for parallelism
Some databases may show a NULL collation in the sys.databases DMV
While working on my Swart’s Ten Percent Rule post last week, I needed to test the Windows version of the script on my SQL Server… Read More »Some databases may show a NULL collation in the sys.databases DMV
Dates and Times in SQL Server: DATEDIFF() and DATEDIFF_BIG()
Last time we looked at adding or subtracting date parts using the DATEADD() T-SQL system function. This week we see how to calculate the difference… Read More »Dates and Times in SQL Server: DATEDIFF() and DATEDIFF_BIG()
String or binary data would be truncated: get the full picture in SQL Server 2017
SQL Server 2019 Preview (CTP 2.0) introduced a long-awaited improvement to an error message that’s been around in SQL Server for many years, but was… Read More »String or binary data would be truncated: get the full picture in SQL Server 2017
Create a slipstream installer for SQL Server on Windows
Since the release of SQL Server 2008 Service Pack 1 in April 2009, it has been possible to install SQL Server with media that includes… Read More »Create a slipstream installer for SQL Server on Windows
Dates and Times in SQL Server: AT TIME ZONE
Continuing the series on dates and times in SQL Server and Azure SQL Database, this week we look at the hint AT TIME ZONE. In… Read More »Dates and Times in SQL Server: AT TIME ZONE
Repair SQL Server on Linux after an Ubuntu distribution upgrade
SQL Server 2017 is supported on Ubuntu 16.04 LTS (Long-Term Support), however that version of Ubuntu Linux is now more than two years old, so… Read More »Repair SQL Server on Linux after an Ubuntu distribution upgrade
Dates and Times in SQL Server: DATENAME()
Last time we looked at DATEPART(). This post is all about the DATENAME() function. So many similarities There are many similarities between DATEPART and DATENAME.… Read More »Dates and Times in SQL Server: DATENAME()
Dates and Times in SQL Server: DATEPART()
In my previous posts in this series we’ve seen reference to Transact-SQL (T-SQL) functions that are used to get the specific part of a date… Read More »Dates and Times in SQL Server: DATEPART()
Dates and Times in SQL Server: the problem with DATETIME
Recently I wrote a post about date and time functions you should never use, which contained an opinion I’ve expressed previously that some people have… Read More »Dates and Times in SQL Server: the problem with DATETIME
Dates and Times in SQL Server: DATETIMEOFFSET
This post continues our look at date and time data types in SQL Server. SQL Server 2008 introduced new data types to handle dates and… Read More »Dates and Times in SQL Server: DATETIMEOFFSET
- « Previous
- 1
- 2
- 3
- 4
- Next »