curatedsql.com
Open in
urlscan Pro
172.241.24.147
Public Scan
URL:
http://curatedsql.com/
Submission: On May 12 via manual from HU — Scanned from DE
Submission: On May 12 via manual from HU — Scanned from DE
Form analysis 3 forms found in the DOM
GET https://curatedsql.com/
<form role="search" method="get" class="search-form" action="https://curatedsql.com/"><label class="screen-reader-text">Search</label><input type="search" class="search-field" placeholder="Search..." value="" name="s" title="Search for:"
tabindex="-1"></form>GET https://curatedsql.com/
<form role="search" method="get" class="search-form" action="https://curatedsql.com/"> <label class="screen-reader-text" for="search-field">Search</label> <input id="search-field" type="search" class="search-field" value="" name="s"
title="Search for:" placeholder="Search for..."> <input type="submit" class="search-submit" value="Search"> </form>GET https://curatedsql.com
<form action="https://curatedsql.com" method="get"><label class="screen-reader-text" for="cat">Categories</label><select name="cat" id="cat" class="postform">
<option value="-1">Select Category</option>
<option class="level-0" value="8">Administration (1,618)</option>
<option class="level-0" value="61">Analysis Services (171)</option>
<option class="level-0" value="41">Architecture (288)</option>
<option class="level-0" value="89">Availability Groups (168)</option>
<option class="level-0" value="113">Azure Data Studio (145)</option>
<option class="level-0" value="117">Azure SQL Edge (3)</option>
<option class="level-0" value="56">Backups (313)</option>
<option class="level-0" value="115">Big Data Clusters (38)</option>
<option class="level-0" value="43">Biml (84)</option>
<option class="level-0" value="101">Bugs (115)</option>
<option class="level-0" value="59">Business Intelligence (43)</option>
<option class="level-0" value="6">Cloud (1,656)</option>
<option class="level-0" value="92">CLR (20)</option>
<option class="level-0" value="60">Clustering (13)</option>
<option class="level-0" value="81">Collations (11)</option>
<option class="level-0" value="49">Columnstore (149)</option>
<option class="level-0" value="48">Compression (30)</option>
<option class="level-0" value="38">Configuration (25)</option>
<option class="level-0" value="100">Constraints (55)</option>
<option class="level-0" value="110">Containers (275)</option>
<option class="level-0" value="57">Corruption (29)</option>
<option class="level-0" value="95">Data (126)</option>
<option class="level-0" value="15">Data Lake (136)</option>
<option class="level-0" value="67">Data Loading (19)</option>
<option class="level-0" value="21">Data Modeling (62)</option>
<option class="level-0" value="18">Data Science (634)</option>
<option class="level-0" value="65">Data Types (122)</option>
<option class="level-0" value="36">Dates and Numbers (148)</option>
<option class="level-0" value="45">DAX (175)</option>
<option class="level-0" value="34">DBCC (62)</option>
<option class="level-0" value="76">Deployment (203)</option>
<option class="level-0" value="112">DevOps (91)</option>
<option class="level-0" value="40">Documentation (78)</option>
<option class="level-0" value="83">Durability (6)</option>
<option class="level-0" value="99">Elasticsearch (43)</option>
<option class="level-0" value="66">Error Handling (247)</option>
<option class="level-0" value="25">ETL (299)</option>
<option class="level-0" value="29">Extended Events (174)</option>
<option class="level-0" value="64">Filestream (9)</option>
<option class="level-0" value="111">Graph (42)</option>
<option class="level-0" value="72">HA / DR (45)</option>
<option class="level-0" value="75">Hadoop (1,304)</option>
<option class="level-0" value="93">Hardware (40)</option>
<option class="level-0" value="68">Hashing (1)</option>
<option class="level-0" value="63">In-Memory OLTP (80)</option>
<option class="level-0" value="4">Indexing (291)</option>
<option class="level-0" value="44">Integration Services (204)</option>
<option class="level-0" value="85">Internals (240)</option>
<option class="level-0" value="118">IoT (11)</option>
<option class="level-0" value="30">JSON (74)</option>
<option class="level-0" value="121">KQL (77)</option>
<option class="level-0" value="109">Learning (166)</option>
<option class="level-0" value="55">Licensing (41)</option>
<option class="level-0" value="10">Linux (188)</option>
<option class="level-0" value="32">Locks, Blocks, and Deadlocks (108)</option>
<option class="level-0" value="71">Log Shipping (16)</option>
<option class="level-0" value="96">Machine Learning (360)</option>
<option class="level-0" value="62">Master Data Services (10)</option>
<option class="level-0" value="39">MDX (2)</option>
<option class="level-0" value="77">Meta (19)</option>
<option class="level-0" value="88">Mirroring (8)</option>
<option class="level-0" value="105">Misc Languages (296)</option>
<option class="level-0" value="5">Myth-Busting (23)</option>
<option class="level-0" value="52">Naming (41)</option>
<option class="level-0" value="78">Normalization (14)</option>
<option class="level-0" value="104">Notebooks (123)</option>
<option class="level-0" value="47">Partitioning (49)</option>
<option class="level-0" value="82">Performance Tuning (430)</option>
<option class="level-0" value="123">PGSQL Phriday (16)</option>
<option class="level-0" value="23">Policy-Based Management (5)</option>
<option class="level-0" value="90">Polybase (104)</option>
<option class="level-0" value="116">Power Apps (14)</option>
<option class="level-0" value="28">Power BI (1,621)</option>
<option class="level-0" value="35">Powershell (894)</option>
<option class="level-0" value="54">Profiler (9)</option>
<option class="level-0" value="120">Purview (24)</option>
<option class="level-0" value="17">Python (380)</option>
<option class="level-0" value="50">Query Store (156)</option>
<option class="level-0" value="11">Query Tuning (512)</option>
<option class="level-0" value="16">R (1,182)</option>
<option class="level-0" value="70">Refactoring (3)</option>
<option class="level-0" value="87">Replication (63)</option>
<option class="level-0" value="27">Reporting Services (116)</option>
<option class="level-0" value="53">Research (7)</option>
<option class="level-0" value="108">Resource Governor (11)</option>
<option class="level-0" value="107">Riak (2)</option>
<option class="level-0" value="102">Search (18)</option>
<option class="level-0" value="19">Security (812)</option>
<option class="level-0" value="3">Self-Promotion (29)</option>
<option class="level-0" value="91">Service Broker (21)</option>
<option class="level-0" value="106">Soft Skills (11)</option>
<option class="level-0" value="73">Source Control (75)</option>
<option class="level-0" value="98">Spark (630)</option>
<option class="level-0" value="80">Spatial (31)</option>
<option class="level-0" value="37">SQL Agent (110)</option>
<option class="level-0" value="26">SQL Server Data Tools (33)</option>
<option class="level-0" value="24">SQL Server Management Studio (223)</option>
<option class="level-0" value="33">Statistics (109)</option>
<option class="level-0" value="46">Storage (142)</option>
<option class="level-0" value="74">Stored Procedures (57)</option>
<option class="level-0" value="97">Streaming (281)</option>
<option class="level-0" value="119">Synapse Analytics (202)</option>
<option class="level-0" value="13">Syntax (443)</option>
<option class="level-0" value="69">T-SQL (885)</option>
<option class="level-0" value="20">T-SQL Tuesday (380)</option>
<option class="level-0" value="86">Temp Tables (54)</option>
<option class="level-0" value="31">Temporal Tables (45)</option>
<option class="level-0" value="79">Testing (142)</option>
<option class="level-0" value="94">Tools (176)</option>
<option class="level-0" value="7">Trace Flags (35)</option>
<option class="level-0" value="9">Transactions (34)</option>
<option class="level-0" value="103">Triggers (38)</option>
<option class="level-0" value="14">U-SQL (26)</option>
<option class="level-0" value="1">Uncategorized (77)</option>
<option class="level-0" value="51">Versions (304)</option>
<option class="level-0" value="84">Virtualization (55)</option>
<option class="level-0" value="58">Visualization (604)</option>
<option class="level-0" value="114">Wacky Ideas (49)</option>
<option class="level-0" value="12">Wait Stats (70)</option>
<option class="level-0" value="42">Warehousing (170)</option>
</select></form>Text Content
Press "Enter" to skip to content Curated SQL A Fine Slice Of SQL Server open menu mobile menu toggle button Search * About CURATED SQL POSTS INTEGRATING VBA AND R CODE Published 2023-05-11 by Kevin Feasel Steven Sanderson has become Dr. Moreau. Part 1 shows how to call R code from VBA: > This line defines a subroutine called “CallRnorm”. A subroutine is a block of > code that can be executed repeatedly from any part of the code, and it starts > with the “Sub” keyword followed by the subroutine name and any arguments in > parentheses. Part 2, as you might expect, covers the obverse: > Yesterday I posted on using VBA to execute R code that is written inside of > the VBA script. So today, I will go over a simple example on executing an R > script from VBA. So let’s get into the code and what it does. > > First, let’s look at the Function called “Run_R_Script”. This function takes > four arguments, where the first two are mandatory, and the last two are > optional. Leave a Comment FIXING ORA-26086 IN AZURE DATA FACTORY PIPELINES Published 2023-05-11 by Kevin Feasel Emanuele Meazzo fixes a problem: > Turns out, ADF is rightfully trying to insert the rows in bulk, but Oracle > doesn’t like it when the sink table has triggers, falling back to row by row > insertion seems it’s too much to ask, so you end up with the error. > Searching on the good ‘ol wide web you’ll encounter this solution, that > basically tells you to disable bulkload for the whole Oracle connection by > setting EnableBulkLoad=0 in the connection string. > That wouldn’t work for me, because I’m bulk loading just fine everywhere else, > so either I had to suffer slower performance on all the other inserts by > disabling the bulk insert, or I had to create an additional and separate > Linked Service to Oracle with the bulk insert disabled: doable but adding > maintenance overhead when things change (two secrets to manage instead of > one). > > My solution? Super dumb. Read on for a copy of the error message and Emanuele’s solution. There are two philosophies with regard to dumb solutions: * If a solution is dumb and it works, it isn’t dumb. * If a solution is dumb and it works, it’s still a dumb solution and you just got lucky this time. I’m not quite sure under which category this falls. Leave a Comment CALCULATING RESERVATION-BASED SAVINGS IN AZURE Published 2023-05-11 by Kevin Feasel Saira Shaik reserves some instances: > I have created this dashboard to display the savings made due to the purchase > of Reservations or Savings Plans or by signing the agreement with Microsoft to > get Azure Commitment Discounts (ACD). > This dashboard is helpful for Customers who: > > * Purchased Reservations or > * Purchased Savings Plan or > * Signed Monthly Azure Consumption Commitment (MACC) and got a special > discounted price. > > > Customers can view their savings by uploading the Amortized files into this > Power BI file. Click through to se what the dashboard includes and how it all works. Then, check out Saira’s GitHub repo for the template. Leave a Comment AN OVERVIEW OF AZURE SYNAPSE ANALYTICS Published 2023-05-11 by Kevin Feasel Kevin Chant offers a primer on Azure Synapse Analytics: > In reality, there are a lot of features within Azure Synapse Analytics where > your SQL Server background can prove to be useful. > > By the end of this post, you will have a good overview of Azure Synapse > Analytics. In addition, where your SQL Server background can prove to be > useful. Plus, there are plenty of links included in this post. This is not the slimmest of primers, which makes sense given how broad Synapse is. Leave a Comment WHICH BACKUPS ARE IN A FILE? Published 2023-05-11 by Kevin Feasel Steve Jones didn’t keep ’em separated: > I had a question on multiple backups in a file and had to check my syntax. > This post shows how to see which backups are in a file. > > Note: Don’t do this. Put backups in separate files. Still, if you didn’t follow Steve’s good advice here (or you have an edge case situation where you, for some reason, need to store multiple backups in the same file), there’s a way to check what’s in a file. Leave a Comment FORMATTING VISUALS IN POWER BI DESKTOP Published 2023-05-11 by Kevin Feasel Reza Rad shows off the new visual formatter in Power BI Desktop: > Where is the Format visual option in the new Power BI Desktop? There is a > simple answer to this question, which I explained in this blog and video. This > change applied from March 2023 version of Power BI Desktop, and by the time > you read this article, it might be at general availability and the only way to > format a visual in the Power BI Desktop. I do hope they also keep the old way of formatting visuals, as there appear to be fewer clicks involved. Leave a Comment AN INTRODUCTION TO POLYGLOT NOTEBOOKS Published 2023-05-10 by Kevin Feasel Matt Eland walks us through a sample: > Polyglot Notebooks allows you to create notebooks composed of multiple cells. > These cells can be either markdown cells for documentation or code cells > containing code in either C#, F#, PowerShell, SQL, KQL, HTML, JavaScript, or > mermaid markdown for diagramming. > > This allows you to mix together rich documentation supported by little pieces > of code that progressively expand upon an idea, tell a story, or otherwise > provide insight or information to you as a developer. Click through for the example. The thing I hadn’t realized—because I don’t really do this in Jupyter—is that you can share variables between languages. That’s a fairly useful feature when you want to do most of your work in one language but just happen to need a library using a different language. Leave a Comment AN OVERVIEW OF GOOGLE BIGQUERY PRICING CHANGES Published 2023-05-10 by Kevin Feasel Jeremy Pries gets out the checkbook: > Google has announced that a new tiered pricing model for Google BigQuery will > come into effect in July. If your organization is already a BigQuery customer > or you’re considering it as a data warehouse option, here’s what you need to > know about the new pricing structure. > > As of July 5, 2023, BigQuery will come with three pricing tiers: Standard, > Enterprise and Enterprise Plus. Customers will have the ability to mix and > match these editions to suit various workloads. Read on for what this means and ways you can hope to save some money as a result of the licensing changes. I’m slightly pessimistic about it—only slightly because I’m quite ignorant of BigQuery pricing to begin with, but more than zero pessimism because companies often don’t change licensing terms with the intent of users paying them less. Leave a Comment UPDATES TO ALWAYS ENCRYPTED SINCE 2016 Published 2023-05-10 by Kevin Feasel Aaron Bertrand notes some changes: > In 2015, during the SQL Server 2016 beta, I explored a new feature is this > article, Always Encrypted. This feature finally allowed us to encrypt data at > rest and on the wire, and I showed how beneficial this was and how much more > secure your data could be. I also explained that, as a new feature, some > limitations made it difficult to use and, sometimes, impossible to adopt. > > Several major versions of SQL Server later, how has this feature evolved, and > is it easier to use today? Read on for the answer. Aaron also covers secure enclaves, a big topic for Always Encrypted users. Leave a Comment NTILE AND QUALIFY IN SNOWFLAKE Published 2023-05-10 by Kevin Feasel Kevin Wilkie continues to build a sample: > In our last post, we went over one way to get a sample of data. In the end was > it right? Heck, no – at least not if we wanted a percentage of rows returned. > Now, SAMPLE does work fine if you want a specific number of random rows > returned each time. > > But, let’s face it – sometimes we will be asked for 10% of a table – > especially in this world of Machine Learning. So let’s attempt to find a way > to make this happen, shall we? QUALIFY would be a nice clause to have. Instead, if you’re in the T-SQL world, you’re probably used to creating a common table expression or subquery and then applying a WHERE clause to the outputs of that CTE/subquery. Leave a Comment POSTS NAVIGATION 12…1,422Next SIDEBAR CURATED SQL * About * @CuratedSQL * RSS Search CATEGORIES CategoriesSelect CategoryAdministration (1,618)Analysis Services (171)Architecture (288)Availability Groups (168)Azure Data Studio (145)Azure SQL Edge (3)Backups (313)Big Data Clusters (38)Biml (84)Bugs (115)Business Intelligence (43)Cloud (1,656)CLR (20)Clustering (13)Collations (11)Columnstore (149)Compression (30)Configuration (25)Constraints (55)Containers (275)Corruption (29)Data (126)Data Lake (136)Data Loading (19)Data Modeling (62)Data Science (634)Data Types (122)Dates and Numbers (148)DAX (175)DBCC (62)Deployment (203)DevOps (91)Documentation (78)Durability (6)Elasticsearch (43)Error Handling (247)ETL (299)Extended Events (174)Filestream (9)Graph (42)HA / DR (45)Hadoop (1,304)Hardware (40)Hashing (1)In-Memory OLTP (80)Indexing (291)Integration Services (204)Internals (240)IoT (11)JSON (74)KQL (77)Learning (166)Licensing (41)Linux (188)Locks, Blocks, and Deadlocks (108)Log Shipping (16)Machine Learning (360)Master Data Services (10)MDX (2)Meta (19)Mirroring (8)Misc Languages (296)Myth-Busting (23)Naming (41)Normalization (14)Notebooks (123)Partitioning (49)Performance Tuning (430)PGSQL Phriday (16)Policy-Based Management (5)Polybase (104)Power Apps (14)Power BI (1,621)Powershell (894)Profiler (9)Purview (24)Python (380)Query Store (156)Query Tuning (512)R (1,182)Refactoring (3)Replication (63)Reporting Services (116)Research (7)Resource Governor (11)Riak (2)Search (18)Security (812)Self-Promotion (29)Service Broker (21)Soft Skills (11)Source Control (75)Spark (630)Spatial (31)SQL Agent (110)SQL Server Data Tools (33)SQL Server Management Studio (223)Statistics (109)Storage (142)Stored Procedures (57)Streaming (281)Synapse Analytics (202)Syntax (443)T-SQL (885)T-SQL Tuesday (380)Temp Tables (54)Temporal Tables (45)Testing (142)Tools (176)Trace Flags (35)Transactions (34)Triggers (38)U-SQL (26)Uncategorized (77)Versions (304)Virtualization (55)Visualization (604)Wacky Ideas (49)Wait Stats (70)Warehousing (170) May 2023MTWTFSS12345678910111213141516171819202122232425262728293031 « Apr Period WordPress Theme by Compete Themes. Scroll to the top