Football Update
Well the World Cup is now half way through, 32 games played, 32 games to go. The talk here in...
2010-06-21
489 reads
Well the World Cup is now half way through, 32 games played, 32 games to go. The talk here in...
2010-06-21
489 reads
This Thursday gone, (June 18th) I went to a hotel near Heathrow airport in London for what was titled a...
2010-06-21
797 reads
This is just a short post that uses a contrived example to demonstrate how to find duplicate records in a...
2010-06-18
1,108 reads
This day only comes around once in every four years, we've all been waiting for it for months. It's been...
2010-06-11
591 reads
You can probably tell from some of my more recent posts that I have been doing some work lately on...
2010-06-09
1,684 reads
It's that time of the month again, time for the next round of T-SQL Tuesday posts. This month is being...
2010-06-08
976 reads
I recently installed a new SQL Server 2008 instance on a brand new Windows 2008 R2. When I tried to...
2010-06-07
640 reads
Recently I have been installing a new SQL Server 2008 instance on Vmware vSphere based virtual server, the OS was...
2010-06-04
1,179 reads
I haven’t written anything technical or SQL Server related for that matter on my blog for a few of weeks....
2010-06-03
633 reads
2010-06-02
622 reads
By James Serra
There are three Azure SQL products with so many different deployment options, service tiers,...
By Steve Jones
I hosted this month’s T-SQL Tuesday party with my invitation asking about tracking permissions....
By Steve Jones
I was asked to do some a little thinking and brainstorming recently. Rather than...
Hi we run 2019 ssas std. Yesterday i imported my tabular project to vs...
Code for mssql 2008 DECLARE @CompanyID TINYINT DECLARE @MemNo decimal DECLARE @MemberFrom Integer DECLARE...
I have an execute task(has server list from a table) pointing to foraeachloop foreachloop...
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