SQL Server 2008 and SQL Server 2008 R2 - OUT of SUPPORT July 2019
Both SQL Server 2008 and SQL Server 2008 R2 go out of extended support with Microsoft in July 2019. That’s...
2019-01-02
180 reads
Both SQL Server 2008 and SQL Server 2008 R2 go out of extended support with Microsoft in July 2019. That’s...
2019-01-02
180 reads
Both SQL Server 2008 and SQL Server 2008 R2 go out of extended support with Microsoft in July 2019. That’s fast approaching and as we enter the new year...
2019-01-02
6 reads
It’s been an interesting week here at gethynellis.com. We have been busy with a SQL Server version upgrade for a...
2018-12-28 (first published: 2018-12-07)
1,942 reads
Black Friday (No,not Shopping!), Mad Friday, Frantic Friday or Black Eye Friday is a nickname for the last Friday before...
2018-12-21
162 reads
Black Friday (No,not Shopping!), Mad Friday, Frantic Friday or Black Eye Friday is a nickname for the last Friday before Christmas (Today!) in the United Kingdom.It is the most...
2018-12-21
7 reads
A week is a long time in...
SQL Server Land
A week is a long time in SQL Server land. This week...
2018-12-14
165 reads
A week is a long time in...
SQL Server LandA week is a long time in SQL Server land. This week I have been busy working on a version migration...
2018-12-14
3 reads
A long long time ago, I wrote a blog post showing how to create db_executor role in SQL Server. There...
2018-11-19 (first published: 2018-11-12)
1,818 reads
David has produced a talk all about Sharding. Or if you prefer horizontally scaling your Azure SQL database.
You can view...
2018-10-19 (first published: 2018-10-04)
2,721 reads
You might think that this blog post is out of place here but I'm hoping use some of the data...
2018-08-10
286 reads
By Steve Jones
I started a short thread on Twitter/X and Bluesky recently after leaving the Tesla...
By Steve Jones
Life gets better as you replace transactions with relationships. – from Excellent Advice for...
I’ve been putting together a new PostgreSQL session called “Performance Monitoring for the Absolute...
Comments posted to this topic are about the item Understanding Bit Manipulation Functions: BIT_COUNT,...
Comments posted to this topic are about the item Mixed Backups
Hello, I ran below statements in MS SQL, and got error, but fine in...
I have a complex database with a few filegroups and files. Can I run a backup command like this? (assume file/filegroup names are valid).
BACKUP DATABASE [complex] FILE = N'thirdone' , FILE = N'thirdtwo' , FILEGROUP = N'second' TO DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL16.SQL2022\MSSQL\Backup\complex.bak' WITH NOFORMAT, NOINIT, NAME = N'complex-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10 GOSee possible answers