Almost lost in all the announcements from Ignite was a bunch of amazing new features that were added to the Provisioned Resources/SQL Pool section (read SQLDW functionalities) side of...
2019-11-19 (first published: 2019-11-11)
256 reads
Today was working on SQL Server cursor standard cursor deification would be like this: sqlcursor from (Azure Data Studio) ———————————————————————————————————————– — Declare a cursor for a Table or a View ‘TableOrViewName’ in schema ‘dbo’ DECLARE @ColumnName1 NVARCHAR(50), @ColumnName2 NVARCHAR(50) DECLARE db_cursor CURSOR FOR SELECT name FROM dbo.TableOrViewName OPEN db_cursor FETCH NEXT FROM db_cursor INTO @ColumnName1, @ColumnName2 WHILE @@FETCH_STATUS = 0...
2019-11-19
21 reads
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the essential knowledge you need to know about performance...
2019-11-19
21 reads
I’m a creature of habit. I have my routine when I get to my hotel room on business trips. I have a way I like my email and notes...
2019-11-19
11 reads
(2019-Nov-10) Microsoft has recently announced a public preview of the Wrangling data flows in Azure Data Factory (ADF). What used to be called Power Query in Excel, Query Editor in Power...
2019-11-19 (first published: 2019-11-10)
337 reads
In April, I said I was going to start learning Jupyter Notebooks. It’s November. Let’s get going with your first Jupyter Notebook. A quick aside before we start. I...
2019-11-19
5 reads
You are going to create a multi-subnet Availability Group in Part 3 of our series on how to build a SQL Cluster Lab. First you give the Cluster Name...
2019-11-18 (first published: 2019-11-11)
255 reads
Anecdotally any session_id that’s 50 or less is going to be a system session and anything over 50 will be ... Continue reading
2019-11-18
20 reads
If your organization uses a password policy (there are very good odds these days that it does) and, especially stricter password requirement for administrative users, your might have experienced...
2019-11-18
14 reads
Recently I have had to troubleshoot quite a bit of SQL login issues and often times the issue was with the users active directory user account.I was aware the...
2019-11-18
23 reads
In April, I said I was going to start learning Jupyter Notebooks. It’s November....
I’m a creature of habit. I have my routine when I get to my...
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get...
Comments posted to this topic are about the item Numeric and Decimal, which is...
I have disk space is getting filled up with Analysis OLAP and log location...
I need to install SSRS for report development and deployment. I don't work with...
Ask SSC