In order to vote you have to have filled out your profile on PASS.org. Rather than guess, take a minute to login and go to https://www.pass.org/MYPASS.aspx?viewctl=MyProfile. If you’re eligible...
2019-05-14
3 reads
If you haven’t read the proposed changes yet you should do that first and form your own opinion before reading mine. Thoughts here are high level, not a line...
2019-05-10
71 reads
Notes: Speaker party was well attended which makes it more interesting, the only downside was that the restaurant overall was LOUD, so much so that sometimes you’d have to...
2019-04-13
12 reads
Earlier this year as I thought about what I wanted to try in Orlando related to the SQL community and thought about the time commitment, I realized it was...
2019-04-13
51 reads
Late notes! Great signs at the event, all hand written on flip chart paper. Cheap and effective, the “different” nature of the signs made them easy to spot Rooms...
2019-04-10
11 reads
Today we have a guest editorial from Andy Warren that takes another view of the counter offer from your employer.
2019-04-03 (first published: 2015-09-18)
553 reads
Today we have a guest editorial from Andy Warren that looks at the challenge of getting a counter offer from your employer.
2019-04-02 (first published: 2015-09-17)
1,306 reads
I’ll be in South Florida again this year and will stay over as usual for a couple days of vacation....
2019-02-18
159 reads
I’ll be in South Florida again this year and will stay over as usual for a couple days of vacation. I see Brent is attending; I’ll have to make...
2019-02-18
4 reads
Today we have a guest editorial from Andy Warren as Steve is away on vacation. This was originally published on Dec 23, 2014. I was reflecting recently on my first real IT job. It was a small-ish company when I joined it, perhaps a hundred employees or so, and still using a mishmash of software […]
2019-02-18 (first published: 2014-12-23)
198 reads
By James Serra
There are three Azure SQL products with so many different deployment options, service tiers,...
By Steve Jones
I hosted this month’s T-SQL Tuesday party with my invitation asking about tracking permissions....
By Steve Jones
I was asked to do some a little thinking and brainstorming recently. Rather than...
Hi, Does anyone have experience with MEMORYBROKER_FOR_RESERVE ? when suddenly there is somehow constantly...
I just learned that my database was created on my C:\ drive in the...
I am needing to migrate a MSSQL db to MySQL, on a different server...
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