With 30 feet of printed manuals, I'm guessing a moderate sized IT department had something like a technical reference librarian who could research stuff and keep it organized.

At least in my observable universe, most limitations that developers struggle with daily are at the logical level of SQL coding or at the physical modeling level, rather than being...

No doubt widespread traffic congestion would occur on highways and inner city streets globally if a technical glitch (or hack attack) disrupted smartphone GPS capability. Imagine it's 4:00pm mid week...

On those occasions the query produces a skewed execution plan, see if you can correlate the point in time with your index and statistics maintenance window. I know that maintenance...

It's unclear if you're asking a modeling question or a security question. For example, are you asking how grant DW users access only to financial data but not HR ?

Maybe add the proxy account to one of the other server roles.

https://docs.microsoft.com/en-us/sql/relational-databases/security/authentication-access/server-level-roles?view=sql-server-2017

For example:

"dbcreator: Members of the dbcreator fixed server role can create, alter, drop, and restore any database."

Rather than dropping the table, I'd reccomend denying select permission, and then wait at least 45 days before dropping it.

As a DBA and developer, I personally don't need an AI to help me write my code. However, I could really use an AI to monitor my servers, maybe even...

Do we really need AI driven application development?

Just like AI driven cars, it's an interesting concept, and I'm sure it's in our future, but at least here an now, there...

Yes, an index recommendation should be treated like a pharmaceutical add: always consult your DBA, and stop using the index when database bloating and slowness of data movement occurs.

null

• This reply was modified 6 years, 6 months ago by Eric M Russell.

I don't know about AI (ie: speech to code) driven application development, but meta-data driven application development certainly is a thing. T-SQL is adept at generating code. The example below...

• This reply was modified 6 years, 6 months ago by Eric M Russell.

"..The longer I’m in this business, the more I think that many people with 5 years working with SQL Server usually don’t have 1 year of experience 5 times. I’m...

Storage Explorer, Data Explorer, Data Studio, Visual Studio, Visual Studio Express, Visual Studio Code, Data Tools:

Which of these are in the process of being deprecated?

If a stored procedure isn't an option, then another safe guard would be to grant the mssql account used by the Contact page to have only insert permission on this...