Excel is a marvelous tool for presentation and analysis, but .XLS and .XLSX are terrible formats for data interchange.

There have been cases where the business would submit excel documents...

It's important that the DBA be an integral team member. Include their database development and deployment tasks as part of sprint planning and invite them to daily stand-up meetings. Invite...

Let this archived thread be an enduring lesson to anyone currently in the process of building a database...

If you are the DBA (or simply the person sitting closest to the database server), then probably the best thing you can do to improve performance is educate yourself about...

sp_MsForEachDB may not be officially documented by Microsoft, but back in 2007 an anonymous member of Microsoft's SQL Server team did obliquely acknowledge it's existence.

https://connect.microsoft.com/SQLServer/feedback/details/264677/sp-msforeachdb-provide-supported-documented-version

Phil Parkin (10/4/2016)

---

New Born DBA (10/4/2016)

---

Experts,

Is is possible to create multiple tables with same tablename and column in multiple databases without selecting each database from the drop down menu and...

You can use a Derived Column transformation task between source and destination, or you can modify SQL to cast the column as specific data type.

For example: CAST( col1...

OK, I thought he said stored procedure earlier, so scratch that.

So, you have this flat denormalized table containing nearly 100 million rows and 100+ columns. The problem is you need to report from it; performing rollups at various levels, aggregation...

If for whatever reason the extended event trace doesn't give you what you need about input parameter values, then can also implement procedure call auditing using a table and adding...

If I understand you correctly, you have a table containing a significant amount of history, much of which you believe can be archived elsewhere. You now want to know the...

Gary Varga (10/4/2016)

---

So now everyone and their grandma is going to ask us to secure their IoT lightbulb because it is going to be "their" responsibility. Legally, would it then...

When in the role of a candidate, I'll typically ask why the previous person in the position decided to leave, or why he/she was let go. It's a good one...

Perhaps the procedure you are executing is calling the other procedure. Look at the T-SQL contents to confirm. That would be my first guess.

Are you asking how to SQL query a text file?

If so, then you canuse OPENROWSET function.

https://msdn.microsoft.com/en-us/library/ms190312.aspx