It’s no secret that I’m keen to investigate new technologies. While my job is almost completely related to “on premises” versions of SQL Server, I’m hugely interested in what the future brings. Learning about new technologies can be difficult without a project in mind or specific manufacturer training. Trawling through Youtube for training can be…
Patching a large SQL Server estate can be a big job. Where possible, tools such as Ivanti HEAT can be used to deliver and install patches, but this doesn’t always work. Some patching needs to be done manually – e.g. where applications or users need to be managed or when dealing with High Availability situations…
While closely monitoring a query that I was running, I observed some strange behaviour by another query. This other query quickly beat mine in terms of Pages read, which is fine, no competition. It went on to exceed it 4 x. The thing that stuck out was the “Degree of Parallelism” that it used –…
Recently, I had a situation where a lot of data needed to be deleted. This was caused by a Monitoring system which was incorrectly configured. When Monitoring, you should Monitor just the information that you need, but no more. In this case, far too much information was being monitored and recorded, causing the Database that…
I’ve recently been getting more familiar with Power BI, thanks to an excellent on-site training course delivered by Stuart and Alison from Burning Suit training. It was great to be supported by my employer with some on-site training, especially in a product that holds so much potential. Power BI has been of interest to me…
How can a Table increase in size when you reduce the size of a column? This came up again a few days ago as one of my Developer friends took heed of my comments about using “appropriate Data Types” for Data Storage. They worked out that using BIGINT to store a Client number was probably…
I was troubleshooting an issue in Dev with SQL Server Reporting Services. As part of the work, I decided to patch the environment to see if that might help. Patches often resolve issues, and give you a few new issues too – let’s call it “the bug exchange”. SQL Server Reporting Services (SSRS) is a…
This Checklist came about after installing additional SQL Server Instances on existing Servers and finding that a bit of additional work was required before Users could access. It’s equally valid for default installations of SQL Server. Allow remote connections to this server This is the suggestion that most “helpful” users provide when they report that…
There’s a lot of talk at the moment about how Cloud services will rapidly replace “On Premises” SQL Server. Snowflake, one of the major players in the Data Warehouse space offers just this, with the promise of “no requirement for a DBA”. Surely a tempting proposal, but should this be a concern for us?…
I received a request for help today from a friend (let’s call him “Dave”). Dave was looking for a better way to deploy projects across a large number of Databases spread over multiple Servers. My initial response suggested looking at scripting – either using SQLCMD or Powershell. Alternatively, there are tools such as Redgate’s “MultiScript”…
By continuing to use the site, you agree to the use of cookies. more information
The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.