Recently at a training I was asked how to implement DAX Time Series functions like parallel period and YTD in PowerBI. I always assumed that I had something […]
Tuning SQL Server – Simulating Performance issues
Check out the second video on our series on Tuning SQL Server. After explaining the data model in the first video, where we cover the process by which […]
Working with Filetable to upload documents into SQL Server
A simple script on how to setup and work with file tables in MS SQL Server. This basically does the bare minimum to setup and create filetables in […]
How to reset password for all users in WordPress site within MYSQL databases
A typical installation of WordPress usually has MySQL database as the backend, recently I found a need to reset the password for multiple users in one go. Here […]
SQL 2019:- sp_estimate_data_compression_savings
This procedure allows us to estimate the potential space savings on a table before we apply a compression algorithm. It’s not exactly a new feature of SQL 2019 […]
SQL 2019:- sys.dm_db_page_info
So we have a new DMF to allow us to view details for the page something I do very often during trainings using the DBCC Page Utility. I […]
SQL 2019:- APPROX_COUNT_DISTINCT
A function that might prove useful when querying very large datasets, it provides a count of distinct values for any column in the database except text,ntext , image […]
administration / Errors / TSQL
To accomplish this action, set property PartitionScheme
SSMS 18.X error when creating NonClustered index This seems to be a bug in SSMS as the index can be created using TSQL just fine here is the […]
Installing SQL 2019 CTP 2.0
It’s finally out and it’s going to be awesome but there is only one way to find out, so here is the very first step, installing SQL SERVER. […]
Why does the query throw NULL and Schrödinger’s cat?
An interesting problem came up in #SQLHelp today. The query is fairly simply and aims to generate a random distribution of value 1,2 and 3. I am not […]