Payment and the Board
If you read the March PASS Board meeting minutes, you saw that there was a discussion around board members and...
2016-04-20
482 reads
The Scary DBA
A View Is Not A Table
Blog post #4 in support of Tim Ford’s (b|t) #iwanttohelp, #entrylevel
In SQL Server, in the T-SQL you use to query...
2016-04-19 (first published: 2016-04-12)
3,125 reads
Views and Simplification
I’ve been getting lots of questions on views lately. Must be something in the water.
Because SQL Server allows you to...
2016-04-05
545 reads
Speaker of the Month: April 2016
THIS IS NOT AN APRIL FOOL POST!
Seriously.
My Speaker of the Month for April 2016 is Keith Tate (b|t) and his...
2016-04-01
489 reads
Do You Teach Azure Data Platform?
I offer instruction on the Azure Data Platform, and have for about six years, since shortly after it came out....
2016-03-29
811 reads
Query Store and Optimize For Ad Hoc
I love presenting sessions because you get so many interesting questions. For example, what happens with Optimize for Ad Hoc...
2016-04-11 (first published: 2016-03-28)
1,928 reads
Happy Dance!
I’m all like:
Because I saw this on an eval:
I’ve been trying to ramp up to take advantage of my MSDN...
2016-03-25
977 reads
PASS Board 2016: Update #2
Time flies. I didn’t notice that I hadn’t posted an update in February.
There’s been a lot going on since I...
2016-03-24
421 reads
Cross Database Query in Azure SQL Database
You can’t query across databases in Azure SQL Database… or can you?
Let’s check. I’ve created two new databases on an...
2016-03-28 (first published: 2016-03-21)
3,112 reads
Opportunities To Talk
It’s weird being an introvert who likes to talk to people, but what can I do. I like talking to...
2016-03-17
455 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