The release of SQL Server 2016 was a huge step forwards in terms of security with Always Encrypted, Dynamic Data Masking and Row-Level Security all new additions to the platform. It’s fair to say that until then security had taken a
One of my favourite questions to ask during our SQL performance training is whether people think an index scan is better or worse than an index seek. Normally most people will go for the worse option and sure, in many
Automation is a big deal right now and whilst an important part of the relatively new DevOps culture it’s actually been an integral part of many, if not all IT roles for a long long time. Automation done well provides
The adoption of DevOps working practices undoubtedly brings lots of advantages to an IT department but the rush to change existing practices can often lead to significant bumps on the road to transformation. A common mistake is to place existing processes in
Consultant David Alcock writes about his views on the shifting technical landscape and with it, the future of the DBA role: http://sqlclarity.blogspot.co.uk/2017/08/the-future-of-dba-role.html
Microsoft recently unveiled a new command line tool that enables users to script out database objects in a very similar way to the Generate Scripts function within Management Studio. The tool is created in Python and that means a quick
One of the most useful but yet underused pieces of native troubleshooting functionality is the system stored procedure sp_server_diagnostics. This returns a lot of information and is very handy using on client installations where we might not have access or
We’ve just published a new article on SQL Shack, the Apex SQL community website! This time we’re focusing on a core activity of Database Administrators, monitoring SQL Server instances. In this post we show you how to query activity information using
We’ve have a new post featured on SQL Shack, the Apex SQL community website where we demonstrates SQL Servers Buffer Pool utilisation and how you can monitor usage; you can read the full article here.
We have a new post to share! David Alcock writes about Monitoring Memory Clerk and Buffer Pool Allocations over at SQL Shack, the ApexSQL community website. You can check out the article here.