Your Lack of Documentation is Costing You More Than You Think
You’ve got a mountain of work to get done and not enough time to do it in. There’s simply just not...
2011-02-01
1,499 reads
You’ve got a mountain of work to get done and not enough time to do it in. There’s simply just not...
2011-02-01
1,499 reads
Being average is dull. Are we consistently producing quality that we can be proud of, each and every time? So...
2011-01-25
569 reads
If you truly desire to be an effective SQL Server Database Administrator then you absolutely must have a buddy.
SQL Server...
2011-01-19
2,790 reads
If you truly desire to be an effective SQL Server Database Administrator then you absolutely must have a buddy.
SQL Server...
2011-01-18
1,901 reads
Is it just me or has the community done the whole “What are my goals for this year” thing to...
2011-01-11
643 reads
Do you understand the value of your time? I mean really understand it. Time is your absolute number one most valuable asset. Once...
2011-01-04
1,418 reads
It’s that time of the month again, no not that one, it’s T-SQL Tuesday time and this weeks topic is...
2010-12-14
657 reads
Did you catch the brilliant and thought provoking editorial post Life Without a Net by Rodney Landrum on SQL Server...
2010-11-02
411 reads
Whilst enjoying my coffee fix this morning, along with today’s SQL Server Central Email, my attention was caught by Steve...
2010-09-09
344 reads
What are the character traits of outstanding SQL Server Database Administrators (DBA) ?
You know what I’m talking about. There are...
2010-08-24
968 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 we run 2019 ssas std. Yesterday i imported my tabular project to vs...
Code for mssql 2008 DECLARE @CompanyID TINYINT DECLARE @MemNo decimal DECLARE @MemberFrom Integer DECLARE...
I have an execute task(has server list from a table) pointing to foraeachloop foreachloop...
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 GOSee possible answers