Popular Posts

SQLblog.com - The SQL Server blog spot on the web

Tuesday, March 6, 2018

How to Suck at Database Administration

SQLServerCentral.com Articles
How to Suck at Database Administration

Tara Kizer outlines 15 telltale signs that you aren't a very good senior DBA.

XML parsing: semicolon expected

SQLServerCentral » Latest topics
XML parsing: semicolon expected
I know the "XML parsing: semicolon expected" error is a data error, and not a SQL error.  The first error I am trying to get rid of is the one about DTD subsets, so I am using CONVERT(xml, xml_data, 2), but then I get this:
Msg 9411, Level 1

Monday, March 5, 2018

Comic for 2018.03.04

RSSMix.com Mix ID 8239024
Comic for 2018.03.04
New Cyanide and Happiness Comic

"But It Worked in Development!" - 3 Hard SQL Server Performance Problems

SQLServerCentral.com Articles
"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

SQLServerCentral » Latest topics
Error when having 2 CTEs
This code results in
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

SQLServerCentral » Latest topics
Need advice on how to process Access DBs with different table structures into SQL Server
I'm looking for some guidance on how to use SSIS to process Access database files into SQL Server.  I know how to process flat files thanks to a lot of good tutorials I've found but when it comes to Access DB files I've only seen cases where all the

Comic for 2018.03.03

RSSMix.com Mix ID 8239024
Comic for 2018.03.03
New Cyanide and Happiness Comic

query just runs; possible join issue?

SQLServerCentral » Latest topics
query just runs; possible join issue?
This report used to run until i added the CTE to pull MAX Created date from the Broker Feed table.
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.

SQLServerCentral » Latest topics
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

SQLServerCentral » Latest topics
how to let the recovery model set forever as simple
Dear Friends

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

SQLServerCentral.com Articles
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.

Comic for 2018.03.02

RSSMix.com Mix ID 8239024
Comic for 2018.03.02
New Cyanide and Happiness Comic

Thursday, March 1, 2018

Using a view to implement SCD2 processing (preventing deadlocks)

SQLServerCentral » Latest topics
Using a view to implement SCD2 processing (preventing deadlocks)
Hi,

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

SQLServerCentral.com Articles
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

SQLServerCentral » Latest topics
Trying to get an SFTP process for SSIS
Hi,

 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