Precedence Goes to Query Store or Plan Guide?
While presenting at SQLDay in Wroclaw, Poland, on the Query Store, I was asked a pretty simple question, which takes...
2016-05-31
938 reads
The Scary DBA
A Moment For Reflection…
While this is a personal blog, I try to keep it focused on either technical topics or personal development and...
2016-05-25
485 reads
On the Buckeye Blitz!
In just a few weeks I’ll be doing the Buckeye Blitz. That is, a tour of user groups in Ohio...
2016-05-24
535 reads
PASS Board 2016: Update #3
I didn’t post an update last month, but I did do something more important: I elicited your feedback on a question...
2016-05-23
383 reads
Query Store, Forced Plans, and New Plans
I love questions. I recently received one about new plans in the Query Store (available in Azure SQL Database now and in...
2016-05-23 (first published: 2016-05-16)
2,707 reads
Use The Correct Data Type
Blog post #5 in support of Tim Ford’s (b|t) #iwanttohelp, #entrylevel. Read about it here.
Saying that you should use the...
2016-05-18 (first published: 2016-05-12)
1,987 reads
Implicit Conversion and Performance
Letting SQL Server change data types automatically can seriously impact performance in a negative way. Because a calculation has to be run...
2016-05-03
587 reads
How to Convince the Boss to Send You to PASS Summit
August two years ago I originally posted, Make the PASS Summit Work for Your Employer. After conversations at several SQL...
2016-05-02
969 reads
Customizing Your Azure Portal
Not all of us are going to use Azure in the same way. That’s just common sense. Therefore, not all...
2016-04-27
1,830 reads
Microsoft’s Commitment to Azure
For several years, many of us who were involved with working in Azure from the early days, were concerned that...
2016-04-21
520 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
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...
how do you manage new columns in a tabular table
Hi we run 2019 ssas std. Yesterday i imported my tabular project to vs...
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