I just started a SQL Profiler trace on my (local) instance and then did the "New Database.." dialog. There are quite a few things that SSMS does in the background,...

Just recently, the Standard edition of SQL Server 2016 SP1 is inheriting most (or maybe all?) of the Enterprise edition features it has traditionally excluded. Hopefully, backup encryption is feature...

When users create a new database, are they specifying a non-default file location or growth size?

Just doing a Google search on filetype:mdf turns up a lot of hits. Some of them are references to NorthWind or AdventureWorks, but others it's not clear. I havn't tried...

A prepared query is paramaterized and can be...

Sadly, in most IT shops it's the application developers to do most of the "interesting" database development work, and even the most senior members of the DBA team perform post-deployment...

As a start, you can combine sp_MsForEachDB with a query against INFORMATION_SCHEMA or SYS views.

For example:

-- Search for all stored procedures and views that include a keyword in their definition:

exec...

Budd (11/18/2016)

---

PLEASE tell me what needs to be done to make something like this work?

DECLARE @PARAM1 VARCHAR(2000) = 'Tom','JOE','BUDD','TIM' --< Obviously this wont work

Select name from employees...

I doubt Microsoft would let the ETL/Integration and BI components...

ZZartin (11/17/2016)

---

...

I happen to really like the windows 10 UI, it's a nice blend of the old windows UI with the better elements of the metro UI available in a...

While the original approach of excluding "enterprise" features from Standard Edition was to encourage folks to splurge on the Enterprise Edition license, as we see now, including these features in...

In terms of the Kimball methodology of star-schema modeling, I believe this would be an example of a "role playing dimension".

For what it's worth, the @@ROWCOUNT system variable contains the number of rows affected by the immediately preceeding DML operation.

What is the first policy?

Especially for lower tier servers (ie: 4 CPU / 8 GB memory), or instances where the database engine is the only service running, it's hard to justify the OS memory...