Face it, you never intended to become a SQL Server expert, but the proliferation of this database engine – and its many editions – requires somebody to feed and care for it. You're the "Microsoft Guy" (or Gal), so whether you wanted to be or not, you were elected. This series of articles is all about making you more effective with SQL Server as an administrator, not a programmer.
How do you earn trust online? How do you decide who to trust? Steve Jones comments a bit about this this works in the digital world.
How do you earn trust online? How do you decide who to trust? Steve Jones comments a bit about this this works in the digital world.
How do you earn trust online? How do you decide who to trust? Steve Jones comments a bit about this this works in the digital world.
With the GDR release, a whole new set of deployment functionality has become available to VSTS: DB.
Most companies in a recent survey expect to get hacked this year. Steve Jones wishes that the technological leaders would help everyone develop more secure code by publishing more information.
Changing a database an integral and crucial part in every application's life cycle. Part 1 of this series looks at the steps and procedures prior to implementing the change
We look at performing the same task for the sys.dm_db_index_operational_stats Dynamic Management Function (or DMF.) The process is identical, the code is however quite different due to the structural differences between sys.dm_db_index_usage_stats and sys.dm_db_index_operational_stats.
Part 1 discussed ways to find opportunities, Part 2 was about how to get more interviews, and today we’ll cover some tips from the employer perspective. Don’t use an AOL.com email address. Seriously. Gmail, Live, Yahoo, all are good, but AOL.com makes...
In this SQL School video, Andy Warren shows how you can alter a table to add a computed column. This is part 1 of 2.
Reading tutorials is fine. Shipping something is better. If you are trying to break...
By Steve Jones
We work hard at Redgate, though with a good work-life balance. One interesting observation...
By Arun Sirpal
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...
Comments posted to this topic are about the item Liability for AI Errors
Hello , I would like to run a stored procedure on a secondary replica...
Comments posted to this topic are about the item Pro SQL Server Internals
I run this command to start SQLCMD:
sqlcmd -S localhost -E -c "proceed"At the prompt, I type this (the 1> and 2> are prompts):
1> select @@version 2> goWhat happens? See possible answers