What Prevents You From Securing Your Servers?
Reading about how hackers are using SQL Server instances that are exposed on the internet AND have weak passwords to work into systems, I’m sitting here wondering why. I...
2020-04-06
66 reads
Grant Fritchey
- Twitter: @https://twitter.com/gfritchey
- Website: https://scarydba.com
- LinkedIn: https://www.linkedin.com/in/grant-fritchey/
- Bluesky: https://bsky.app/profile/gfritchey.bsky.social
Time To Learn Git
I love this quote from Kevin Hill (and not because he mentions me): 3 things I can no longer justify ignoring: #dbatools Git and #Docker for my dev SQL work@cl@sqldbawithbeard@Kendra_Little and @unclebiguns@GFritchey, I blame you...
2020-04-03 (first published: 2020-03-26)
1,094 reads
DB Automation with Azure DevOps
I sincerely believe the key to your future as a DBA is your ability to automate everything you do. However, the single hardest thing that you have to do...
2020-03-31 (first published: 2020-03-25)
445 reads
Unit Testing & Intelligent Query Processing
Actually, these two topics don’t have anything to do with one another. I just ran out of days to promote everyone individually who was taking part in putting on...
2020-03-31
6 reads
Extended Events: Queries and Waits
Wouldn’t it be great to be able to put together queries and waits at the same time? You all capture query metrics using some method. Most of us query...
2020-03-30
10 reads
Containers and DevOps
Over the last couple of years, one of these single most exciting technologies to come out around the Data Platform has been containers. You may not see them change...
2020-03-27 (first published: 2020-03-20)
300 reads
Figuring Out How To Hide Production Data
There’s a really simple conundrum that we go through all the time. The best data for development is production You can’t have production data for development You have to...
2020-03-27
137 reads
Being an Efficient DBA
Or database developer, report writer, whatever. SQL Server, SQL Server Management Studio, and all the tools provide a bunch of ways to get things done. However, some ways are...
2020-03-24
44 reads
Extended Events: Live Data Explorer, Getting Started
One reason a lot of people don’t like Extended Events is because the output is in XML. Let’s face it, XML is a pain in the bottom. However, there...
2020-03-24 (first published: 2020-03-16)
253 reads
Extended Events: Live Data Explorer, Grouping
Of all the things that Extended Events does, I’ve found the ability to quickly and easily gather a little bit of data and then use the Data Explorer window...
2020-03-23
93 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