Finding The Active Sharepoint Databases
This was a task from last week. There was a server where we wanted to make some adjustments to security...
2013-09-23
905 reads
SQLAndy
Notes from SQLSaturday #232 in Orlando
Our seventh annual SQLSaturday here in Orlando went well. To the casual observer it might appear to happen without effort,...
2013-09-16
660 reads
My 2013 PASS Suggestion Tsunami List
Back in August I posted about an approach that Aaron Nelson and I thought of to try to get more...
2013-09-09
791 reads
Log Backup Failing–A Simple Mistake
Last week I was checking on some stuff and noticed that a couple databases were in simple mode – unusual, but...
2013-09-05
695 reads
Skills I Used Last Week
Ever thought about what your average week looks like? What are the real core skills your environment uses every day...
2013-09-09 (first published: 2013-09-03)
2,417 reads
Building a Better Litter Box
First, I know as I write this that my friend Kevin will be emailing me later today that I’ve jumped...
2013-08-30
1,423 reads
Notes From The August 2012 OPASS Meeting
Luis Figueroa did a nice job presenting on Master Data Management. It’s nice to see the tools evolving, though I’ll...
2013-08-23
613 reads
Need Recommendations on Being a Better Listener
This past weekend I’ve been reading The Zen of Listening by Rebecca Shafir, part of my ongoing efforts to be...
2013-08-19
682 reads
Interview Candidates for Skills, Aptitude, Maybe Both
Over the years I’ve been primary a skills interviewer. In theory I know what skills are needed and in theory...
2013-08-20 (first published: 2013-08-15)
2,438 reads
Be The Connector
Few things are more satisfying than to introduce two people when you think they have common interests. Often it’s driven...
2013-08-14
841 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