Every DBA, owner or CEO etc. have worries regarding their SQL Server. We face challenges everyday with constant evolving business and technology needs. We at Stedman Solutions are interested and concerned about your worries in regards to SQL Server work. What is your biggest SQL Server worry today? Tell us so that we can focus our attention on the issues …
Microsoft has announced that the next version of SQL Server will be SQL Server 2022. This version is currently in the Early Adopters program. Typically after that will come the Community Technical Preview (CTP) Version, which there may be a couple of those. Then it comes to final release or the RTM (Release to Manufacturing) version. Since they have announced …
After the last post on Cumulative Distribution Function (CDF) or as it is known in TSQL CUME_DIST(), I realized that although I showed how to use it, I didn’t really explain what it means, or when to use it. That is where this example comes in. First lets take an example that generates simulated dice rolls. What are the odds …
Cumulative Distribution Function (CDF) – Analyzing the Roll of Dice with TSQL Read more »
Percent rank is defined as the number of values that are the same or less than the current value divided by one less than the number of values. Percent rank is different than PERCENTILE, stay tuned for PERCENTILE_DISC and PERCENTILE_CONT which are different from PERCENT_RANK. For this example I will be using the same revenue table in the sample database …
Here is a quick update on the last 3 podcast episodes that we have published, ending up 2016, and starting out 2017 with some great information from Paul Turley, Jimmy May and Argenis Fernandez. Episode 77: New Reporting Options with Paul Turley We invited Paul Turley on the show to chat with us about some of the new features in …
This weeks latest podcast is an interview with Melissa Coates, on the topic of Cortana Intelligence Suite. From this weeks podcast: The Cortana Intelligence Suite is actually a huge collection of services in Azure for the purposes of providing big data and analytical solutions. So the suite consists of: Azure data factory, data catalog, Azure SQL data warehouse, Azure data …
Cortana Intelligence Suite – Podcast Episode #62. Read more »
Today we released Episode 52 on the SQL Data Partners podcast on the R Programming Language. You might remember a few weeks ago the announcement that I was joining Carlos Chacon as the co-host of the weekly podcast. Episode 52 on the SQL Trail with the SQL Data Partners podcast is with Ginger Grant (@DesertIsleSQL on Twiter) and the topic …
SQL Server – TSQL Analytics Word Search Find the following words in the word scramble above. TOP RANK DENSE_RANK ROW_NUMBER NTILE OVER LAG LEAD FIRST_VALUE LAST_VALUE PERCENT_RANK PERCENTILE_DISC PERCENTILE_CONT CUME_DIST PARTITION ROWS PRECEDING FOLLOWING UNBOUNDED Download the Printable PDF of the Word Search. See Also TSQL Queries – Using NTILE TOP, Ranking, NTILE, and Aggregate Functions TSQL Analytics FREE …
Continuing our weekly SQL Query Training for the 70-461 exam preparation, at Steve Stedman, sharing this weeks class with the world. Free SQL Query training. Here is the video of the training on TOP, Ranking, NTILE, and Aggregate Functions today. The first half was presented by Aaron Buma, and the second half I presented. The following topics …
As posted earlier. This weeks SQL Queries training for the 70-461 certification will be on Thursday at 9:00am (US pacific time). Please join the live broadcast on Google On Air Hangouts, or catch the recorded version on myYouTube Channel. Aaron Buma will be presenting the first half of the session and I will be presenting the second half. We will …