Tara Kizer outlines 15 telltale signs that you aren't a very good senior DBA.
Popular Posts
-
SQLServerCentral » Latest topics More Precedence Comments posted to this topic are about the item [B] More Precedence [/B] more in...
-
SQLServerCentral.com Articles Storing a variable with a SELECT, and why it didn't work. Using SELECT to store values into varia...
-
SQLServerCentral » Latest topics SSRS: Addind a parameter to the dataset query Dear all, I have created in my dataset a parameter n...
SQLblog.com - The SQL Server blog spot on the web
Tuesday, March 6, 2018
How to Suck at Database Administration
XML parsing: semicolon expected
Msg 9411, Level 1
Monday, March 5, 2018
"But It Worked in Development!" - 3 Hard SQL Server Performance Problems
You’ve been performance tuning queries and indexes for a few years, but lately, you’ve been running into problems you can’t explain. Could it be RESOURCE_SEMAPHORE, THREADPOOL, or lock escalation? These problems only pop up under heavy load or concurrency, so they’re very hard to detect in a development environment.
Error when having 2 CTEs
Msg 102, Level 15, State 1, Line 29
Incorrect syntax near ','. That is the between the CTEs. I copied syntax from another report that i wrote that works. Thoughts?
Sunday, March 4, 2018
Need advice on how to process Access DBs with different table structures into SQL Server
query just runs; possible join issue?
Now it just runs . . . Can anyone see an issue?
thanks
[code language="sql"
Saturday, March 3, 2018
How to bring database just before the delete occurred.
Good Morning Experts,
We are taking full backup every saturday at 9PM, differential backup daily at 9PM and transaction log backups every 30 minutes.
A developer accidentally deleted data from table at 2:4
Friday, March 2, 2018
how to let the recovery model set forever as simple
my sql server is with recovery model set to simple, but every day it is changing to full.
how does it leave it forever as simple or how to create a job that changes it to simple?
Thanks
Almir
Introducing a DevOps culture
Your organization’s culture of DevOps will often be the defining factor on whether you have a successful organizational change, or whether the changes that you implement impact pockets of your organization.
Thursday, March 1, 2018
Using a view to implement SCD2 processing (preventing deadlocks)
Question #1:
Scenario:
* I have a series of SCD2 source tables which are updated twice a week.
* I'm creating a downstream series of SCD2 target tables which are updated monthly.
* I am using a delta feed for the staging
Free eBook: SQL Server Transaction Log Management
When a SQL Server database is operating smoothly and performing well, there is no need to be particularly aware of the transaction log, beyond ensuring that every database has an appropriate backup regime and restore plan in place. When things go wrong, however, a DBA's reputation depends on a deeper understanding of the transaction log, both what it does, and how it works.
Trying to get an SFTP process for SSIS
I have been looking all over the web for this. I realize that SSIS does not, on its own handle SFTP. A number of sites suggest using WinSCP, but have not gives a full explanation of how to code for this. Maybe its me but they seem to le