Houston TechFest 2014: SQL Admin Best Practices with DMV's
Awesome crowd this morning for my SQL Admin Best Practices with DMV's presentation at Houston TechFest 2014, thanks very much...
2014-09-13
568 reads
SQL Tact
Restoring Toggle Results Window as Ctrl+R in SSMS
Recent versions of SQL Server Management Studio have unmapped Control+R as the toggle for the Results window in a typical...
2014-09-03
1,844 reads
The Nine SQL Server Careers
Microsoft SQL Server is a mature and broad technology platform that supports a diverse set of careers - this blog post...
2014-09-02
1,481 reads
Painful or Helpful? No SSMS Multiserver Results if One Instance Errors
I've been going back and forth with this question for a few days now.
If one instance in a multiserver query presents an...
2014-09-01 (first published: 2014-08-26)
6,242 reads
SQLSat Birmingham: SQL Server Admin Best Practices with DMVs
Thanks for attending my session today SQL Server Admin Best Practices with DMVs at 8AM!
Here's the link to a .zip file...
2014-08-21
574 reads
SQLSat Birmingham: SQL Server Permissions and Security Principals
Thanks for attending my session today, SQL Server Permissions and Security Principals at 9:15AM!
Here's the link to a .zip file to...
2014-08-21
542 reads
SQL Saturday Birmingham 2014
I'm looking forward to geauxing with a handful of Sparkhound colleagues and friends to speak at SQL Saturday Birmingham on...
2014-08-19
541 reads
SQLSaturday Baton Rouge Business Intelligence and Recap - 2 of 2
(This is the second part of a two-part post on a SQLSaturday Baton Rouge 2014 recap.)
Out of a total of...
2014-08-10
560 reads
SQLSaturday Baton Rouge Business Intelligence and Recap - 1 of 2
(This is the first part of a two-part post on a SQLSaturday Baton Rouge 2014 recap.)
Been quiet on this blog...
2014-08-10
744 reads
SQL Saturday Baton Rouge 2014
Since I have been involved with and eventually head of the Baton Rouge SQL Saturday planning committee each year since...
2014-07-10
696 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