Marketing

Can A Virtual MozFest Live Up To The Real Thing?

4 Reasons A Virtual MozFest Will Live Up To The In Person Festival So when someone asks, “can a virtual MozFest live up to the real thing?”, our answer is a resounding YES! This year’s virtual MozFest is going to be fun, social, experimental, and transformative. It will look different than years past, but the […]

Explore the winning vizzes from Iron Viz: Student Edition from What’s New

Editor’s note: This article originally appeared in Tableau Public[1]. Iron Viz[2]—the world’s largest data competition—was launched in 2011 in an effort to showcase the incredible talent of the Tableau Community. Since then, hundreds of data enthusiasts from around the world have participated for a chance to be crowned the Iron Viz Champion. And in 2020, […]

Best of the Tableau Web: December from What’s New

Happy New Year! Welcome to another year of reviewing the Best of the Tableau Web (BOTW). Can you believe we’re entering the 10th year of this blog series? I personally want to thank every person who shared a tip, detailed technique, analytics that inspired them, or some wacky piece of data art. The Tableau ecosystem […]

It’s 2021, so why are you reading this? from Blog Posts – SQLServerCentral

If you’re reading this, there’s a good chance you’re straight, white, male, and English-speaking. There’s also a high likelihood that you live in the United States. The technology industry seems to be thick with this stereotype, but as I mentioned in a series of posts about gatekeeping, if we only listen to (or read) white-> […]

Daily Coping 20 Jan 2021 from Blog Posts – SQLServerCentral

I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle[1], which is helping me deal with the issues in the world. I’m adding my responses for each day here. All my coping tips are under this tag[2].  Today’s tip is to switch off your tech 2 hours before […]

[Coping] Hidden Wounds from Blog Posts – SQLServerCentral

Through high school and college, I carried deep wounds due to what was going on at home. Only a handful of people outside of my family knew what what was happening. I didn’t want to share what was occurring for a number of reasons: thinking about it brought more pain, it was deeply embarrassing, and […]

Logical crossroads in Azure Data Factory (IF and Filter operations) from Blog Posts – SQLServerCentral

(2021-Jan-19) I was raised listening and reading fairy tales where the main character would reach a crossroad with a large stone that had some directions written on it – turn right and you will lose your horse, turn left and you will lose your life, walk straight and you will find your happiness.  Also, growing up […]

Storage Tiers What SQL Server DBAs Need to Know from Blog Posts – SQLServerCentral

“One Gerbil, Two Gerbils or Three Gerbils?” is a common DBA joke about server and storage performance. No matter how many gerbils power your storage, you need to know what type they are and the power that they provide. Storage is not about gerbils it is about IOPs, bandwidth, latency, and tiers. As a DBA […]

Synapse Analytics and .NET for Apache Spark Example 3 – CTE() from Blog Posts – SQLServerCentral

The next example is how to do a CTE (Common Table Expression). When creating the CTE I will also rename one of the columns from “dataType” to “x”. T-SQL WITH CTE(x, dataType, dataSubType) AS ( SELECT dateTime, dataType, dataSubType FROM chicago.safety_data ) SELECT * FROM CTE; Spark SQL WITH CTE AS (SELECT dateTime as x, […]

What is the CONTROL permission? from Blog Posts – SQLServerCentral

One of the most powerful permissions available in SQL Server is control. But what exactly is it? Per BOL[1]: CONTROL: Confers ownership-like capabilities on the grantee. https://docs.microsoft.com/en-us/sql/relational-databases/security/permissions-database-engine?view=sql-server-ver15#_conventions[2] Ownership-like. So not quite ownership. In essence if you have the control permission you have every stated permission to the object. This includes the ability to grant permissions […]

Daily Coping 19 Jan 2021 from Blog Posts – SQLServerCentral

I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle[1], which is helping me deal with the issues in the world. I’m adding my responses for each day here. All my coping tips are under this tag[2].  Today’s tip is to get moving. Do something physically active (ideally […]

Server Review Essentials for Accidental and Junior DBAs—Setting Up (Part 1) from Blog Posts – SQLServerCentral

Welcome to a new year, and a new look at what I’ve learned in my time as a beginner and junior DBA. So, I’ve been in this DBA gig for just over 1.5 years, and it’s been quite a fun and interesting ride. Many readers have read my Ironic DBA Files posts where I regularly… […]

Azure SQL vCore vs DTU from Blog Posts – SQLServerCentral

If you are building database solutions in Azure , using Azure SQL Database then you will know that you have a purchasing option decision to make. That being should you use a vCore model or DTU approach? Whilst I am … Continue reading ?[1] The post Azure SQL vCore vs DTU[2] appeared first on SQLServerCentral[3]. […]

Synapse Analytics Spark Example 2 – ROW_NUMBER() from Blog Posts – SQLServerCentral

The next example is how to do a ROW_NUMBER(), my favourite window function. T-SQL SELECT *, ROW_NUMBER() OVER(ORDER BY dateTime) as RowNumber FROM chicago.safety_data Spark SQL SELECT *, ROW_NUMBER() OVER(ORDER BY dateTime) as RowNumber FROM chicago.safety_data DataFrame API (C#) var dataFrame = spark.Read().Table(“chicago.safety_data”); var window = Microsoft.Spark.Sql.Expressions.Window.OrderBy(“dateTime”); dataFrame = dataFrame.WithColumn(“RowNumber”, Functions.RowNumber().Over(window)); dataFrame.Show(); To see this […]

Synapse Analytics Spark Example 1 – Group By from Blog Posts – SQLServerCentral

I have been playing around with the new Azure Synapse Analytics, and I realised that this is an excellent opportunity for people to move to Apache Spark. Synapse Analytics ships with .NET for Apache Spark C# support many people will surely try to convert T-SQL code or SSIS code into Apache Spark code. I thought […]

Renaming Files by Padding Numbers with PowerShell from Blog Posts – SQLServerCentral

Some time ago I had downloaded all the SQL Saturday XML files. I’ve been meaning to flatten those into a database, but that project keeps getting away from me. And now it’s become an archive task. In any case, I’ve been looking to work with Jekyll and get a list of events. There is one […]

When do Statistics get updated? from Blog Posts – SQLServerCentral

Statistics objects are important for allowing the SQL Server Optimizer to make good estimates and form efficient execution plans. Related to that it’s useful for us to understand when statistics get updated – and where we might have to update them ourselves. This post details in what scenarios statistics get updated, as well as the […]

A New Resource for AI, Litigation and Human Rights

Atlas Lab helps human rights defenders, including litigators and activists, better understand how issues like machine learning and algorithmic decision-making are intersecting with human rights enforcement. It’s built by Mozilla Fellows Aurum Linh and Jonathan McCully and hosted within the Digital Freedom Fund.[1] Litigation can play a substantial role in shaping and improving human rights […]

Sitemap | Terms | Privacy | Cookies | Advertising

Senior Software Developer

Creator of @LzoMedia I am a backend software developer based in London who likes beautiful code and has an adherence to standards & love's open-source.