(Kalen Delaney) I have been accumulating a list of questions that have come up during my 5-day SQL Server Internals classes, that I cannot immediately answer. Sometimes I can figure out the answer myself with just a bit of research or a simple test, and sometimes I can ask one of my Microsoft contac
Tag: sql server
Coordinate Editing Functions for SQL Server Spatial
(Simon Greener) SQL Server Spatial, unlike spatial database type systems such as PostGIS, does not provide coordinate editing functions:
The Azure SQL Data Warehouse gains an auditing feature
(Jessica Sirkin) Microsoft announced that it had enabled an auditing feature for the Azure SQL Data Warehouse. The new feature has many benefits, but storing audit logs won’t be free.
SQL SERVER – Reading Statistics IO data with SQL Server
(Pinal Dave) I am a supporter of always going to the basics when it comes to performance troubleshooting. Whenever I have done any perf tuning exercise, I start by enabling the Statistics IO as part of my debugging. When STATISTICS I/O is enabled, SQL Server maintains I/O statistics for the queries
Quick Intro to Power BI Visuals Gallery
(Jason Thomas) I don’t usually look forward to Mondays (especially after spending a very exhausting though rewarding weekend organizing SQL Saturday Charlotte), but then today was different.
Time Series Algorithms in SQL Server
(Dinesh Asanka) This is the fourth article on data mining series. The below are the previous articles in this series.
Securing SQL Server with SQL Secure
(Greg Robidoux) SQL Server security is as important and as complex as performance tuning, but the reality is that security sometimes just gets in the way and often takes a back seat to performance related issues. When developing, testing and rolling out new features the main focus is always functio
Quick Intro to Power BI Visuals Gallery
(Jason Thomas) I don’t usually look forward to Mondays (especially after spending a very exhausting though rewarding weekend organizing SQL Saturday Charlotte), but then today was different.
Time Series Algorithms in SQL Server
(Dinesh Asanka) This is the fourth article on data mining series. The below are the previous articles in this series.
Securing SQL Server with SQL Secure
(Greg Robidoux) SQL Server security is as important and as complex as performance tuning, but the reality is that security sometimes just gets in the way and often takes a back seat to performance related issues. When developing, testing and rolling out new features the main focus is always functio