Restoring a Certificate
I have written about creating a certificate and backing up a certificate, and the next step is the restoration of...
2012-03-05
19,146 reads
Blog Posts
RYO Maintenance Plan – Index Maintenance
It’s been a couple of weeks since my last post, but I swear I have a good excuse. I’ve been...
2012-03-05
1,237 reads
SQL Server 2012 (“Denali”): Details on the next version of SSRS
SQL Server 2012 contains six new features for SSRS:
Excel Renderer for Microsoft Excel 2003, 2007 & 2010 - Excel renderer will support the Excel...
2012-03-05
1,595 reads
What Does a Database Administrator Actually Do?
Most people in your organisation, never mind everyone else, have no real clue as to what it is you do.
It’s...
2012-03-05
1,647 reads
Why We Follow Best Practices
Why We Follow Best Practices
Best Practices
There are many reasons why we follow best practices. My own reasons have changed over...
2012-03-05 (first published: 2012-02-26)
3,483 reads
CPU-Z 1.60 Released
Pretty much right on schedule, Frank Delattre has released CPU-Z 1.60, which has support for some new and upcoming processors...
2012-03-04
827 reads
I'm presenting at 24 Hours of Pass!!
Woohoo! I have been selected to present my SSIS Tips & Tricks presentation at this year's 24 Hours of Pass. I am...
2012-03-04
503 reads
New upcoming events across Europe
I'm very happy today to announce 4 new upcoming SQL Server workshops across Europe
within the next months:
SQL Server Configuration...
2012-03-04
915 reads
Oracle Tips for MSBI Devs #1: Executing an Oracle Stored Proc with No Parameters in SSIS Execute SQL Task
Originally posted: 3-4-2012 Welcome to a new blog series of tips related to Oracle with a focus on helping those...
2012-03-04
570 reads
Resource Governor Configuration
Resource Governor(RG) is a technology which introduced in SQL server 2008 to manage the CPU and Memory resource that a incoming session can...
2012-03-04
4,568 reads
Blogs
Azure SQL offerings
By James Serra
There are three Azure SQL products with so many different deployment options, service tiers,...
T-SQL Tuesday #183 Roundup
By Steve Jones
I hosted this month’s T-SQL Tuesday party with my invitation asking about tracking permissions....
A Little Brainstorming with an AI
By Steve Jones
I was asked to do some a little thinking and brainstorming recently. Rather than...
Forums
MEMORYBROKER_FOR_RESERVE experience
Hi, Does anyone have experience with MEMORYBROKER_FOR_RESERVE ? when suddenly there is somehow constantly...
Moving Database Files
I just learned that my database was created on my C:\ drive in the...
Migrate MSSQL to MYSQL - Different Servers
I am needing to migrate a MSSQL db to MySQL, on a different server...
Question of the Day
Mixed Backups
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
GO
See possible answers