Hi Andy,

Let me run this past you.

So, the problem as I understand it is that we really don't need to be informed 1,000,000 times that (for example) an ETL...

First, I'll turn on the radio to NPR news (I hate political\entertainment talk radio and morning rock DJs shows). If there isn't a good feature on, then I'll switch over...

First thing, use a schema comparsion tool to confirm that all the indexes and code changes existing in development have been deployed to production.

Microsoft SQL Server Data Tools

https://msdn.microsoft.com/en-us/library/hh272690(v=vs.103).aspx

Open DBDiff

http://opendbdiff.codeplex.com/

RedGate SQL...

Ha! That's a trick question.

If you had asked how many database servers, then I could give you a total number...

Jeff Moden (10/5/2016)

---

Not really. ...

Maybe for an ISV, you have a group of developers who are always focussed on new development and then another team that does primarily maintenance and enhancement. However, everywhere I've...

I'd also mention the issue of page splitting, fragmentation, fill factor, and how it all relates to choosing the optimal clustering key combination.

https://sqlperformance.com/2015/04/sql-indexes/mitigating-index-fragmentation

Imagine you're stacking books on a shelf sorted...

Like today, within SSMS Object Explorer, you can right click on a stored procedure, table, view, etc. and select 'View Dependencies'.

Still there are occasions where it's useful to query...

Phil Parkin (10/5/2016)

---

If there is one feature I'd love to see added is the ability to stronly type worksheet columns, meaning for example that all values within a column would...

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...