SQL Server DBA, BI Analyst and Microsoft MVP

Posts Archive

Month: February 2017

Back to Archive

Analysis Services - How to create your first multidimensional cube in the star schema model

February 28, 2017 11 min read

Continue reading

SQL Server - Understanding SQL Agent Permissions and Roles: SQLAgentUserRole, SQLAgentReaderRole, SQLAgentOperatorRole

February 28, 2017 7 min read

Continue reading

SQL Server - Implementing Access Control and Audit Logs in CLR (C#) Usage

February 28, 2017 5 min read

Continue reading

SQL Server - How to Transfer Logins Between Instances Generating Reverse Engineering of Users, Logins and Permissions

February 27, 2017 15 min read

Continue reading

SQL Server - How to identify and monitor disks, total, free, and used disk space

February 26, 2017 10 min read

Continue reading

SQL Server - How to export a CLR assembly as a DLL and reverse engineer it to C# source code

February 25, 2017 4 min read

Continue reading

SQL Server - How to back up all SQL Agent jobs via command line (CLR C# or PowerShell)

February 22, 2017 9 min read

Continue reading

SQL Server - How to delete a user from an instance

February 21, 2017 3 min read

Continue reading

SQL Server - How to copy/replicate a user's permissions

February 19, 2017 11 min read

Continue reading

SQL Server 2016 - Using native JSON support (JSON_VALUE, JSON_QUERY, OPENJSON, FOR JSON, ISJSON, JSON_MODIFY)

February 19, 2017 16 min read

Continue reading

SQL Server 2016 SP1 - CREATE OR ALTER in procedures, functions, triggers, and views

February 12, 2017 3 min read

Continue reading

SQL Server - Grouping data using ROLLUP, CUBE and GROUPING SETS

February 12, 2017 9 min read

Continue reading

SQL Server - How to identify, monitor, and prevent overflow in IDENTITY and SEQUENCE columns of tables with many rows

February 8, 2017 6 min read

Continue reading

SQL Server - How to integrate the database with Telegram and send messages using CLR (C#)

February 5, 2017 8 min read

Continue reading

SQL Server - How to integrate the database with Slack and send messages using CLR (C#)

February 4, 2017 9 min read

Continue reading

SQL Server - How to integrate the database with Ryver and send messages using CLR (C#)

February 4, 2017 5 min read

Continue reading

SQL Server - How to send SMS Torpedoes using the CLR (C#) and the Mais Resultado API (PG Soluções)

February 4, 2017 7 min read

Continue reading

Microsoft MCSE 70-774 Certification Exam (Perform Cloud Data Science with Azure Machine Learning) for free (beta) until 03/31/2017

February 3, 2017 2 min read

Continue reading

Microsoft MCSE 70-775 certification exam (Perform Data Engineering on Microsoft Azure HDInsight) for free (beta) until 03/31/2017

February 2, 2017 2 min read

Continue reading

SQL Server - How to rename the server / instance in the database when the machine name is changed in the OS

February 2, 2017 1 min read

Continue reading