Hey everyone, I first want to say a heartfelt thank you so much for the warm comments and supportive feedback I’ve gotten since I announced that I’m in process of writing Fabulous Adventures In Data Structures And… · first, book, access, early, program

Seed Auction November 8th to 16th --- Click HERE Librarians: Carol Brashear Bill Meyer //<![CDATA[ (function() { var _analytics_scr = document.createElement('script'); _analytics_scr.type = 'text/javascript'… · analytics, scr, elem, var, document

Knowing SQL is a must for Data Scientists + other analytics professionals, but how can R users start practicing their SQL skills in a familiar environment? That’s this post! Last week, I shared about how I use R for… · data, spatial, austin, covid, sql

The text-based SQL learning game for data scientists and marketers

A blog about all things PowerShell, SQLBits, Community, dbatools, dbatoolsMoL, dbachecks, Azure, SQL, PSConfEU and more

Here's a scenario that I believe to be common. I've got a dataset I've been collecting over time, with features \(x_1, \ldots, x_m\) This dataset will generally represent decisions I want to make at a certain time. This… · data, here, time, make, relationship

dbskool, database, relational database, database tutorial, sql, plsql, oracle, forms, report, dba, apex, learn database, database model, mysql, orcl

Building the fastest modular execution layer. Building the internet of RollApps. The world's first decentralized analytics platform and data warehouse. · crypto, building, world, decentralized, invest

School: Hi, this is your son's school. We're having some computer trouble. Mom: Oh, dear -- Did he break something? School: In a way. Did you really name your son Robert'); DROP TABLE Students;--? · school, mom, son, did, hope

The last several years I’ve participated in the Joel Kallman Day tributes with articles about SQL and PL/SQL. While there are no requirements for article topics, this year I wanted to contribute something within the… · apex, sql, while, article, region

This blog is focusing on Microsoft Technology. Especially SQL-Server

One of the two SQL Server Speakers of Professional Association for SQL Server in SQLPASS Lahore General Conference. (http://lahore.sqlpass.org/Home.aspx?EventID=5615) 9+ Years of Database Development &amp; Administration experience with Medical Billing, Start up &amp; Financial Companies Microsoft® Certified Solutions Expert: Data Management and Analytics (SQL Server 2012/2014) Microsoft® Certified Solutions Expert: Data Platform (SQL Server 2012/2014)

Brad McKuhen, SQL Server developer and leader, blogging on technology and leadership topics

Michael J Swart's blog about all things database, free articles, tips and tricks. Mostly about SQL in general and SQL Server in particular.

For the past several months, I’ve been attending school full time to learn how to program. Specifically for C#, ASP.NET Core MVC, SQL, and using this to develop web applications for hosting on the Azure platform. To say… · infrastructure, code, wanted, learn, build

I would like to thank all the participants of T-SQL Tuesday #189. If I missed your post, it was not intentional. Please let me know, and I will add it to this list. I am proud of this community and feel lucky to be a small part of it. I admire everyone who joined the blog party and shared their…

I’m just documenting this quickly because it took me a comically long time to figure out where it was in the UI, the official documentation was hard to find, and I hope to save someone from the same goose chase. If you… · time, need, right, support, admin

Hi! Welcome to my corner of the internet. I make software, and am currently working full time on a project called SQLSync. Prior to that I spent a decade building databases at SingleStore and some time creating… · time, welcome, corner, internet, make

Stuff about computers and programming, mostly related to Microsoft SQL Server

This whole post is an off-topic shower-thought type of post, and has nothing to do with SQL Server. But as a fellow technologist, I think you might enjoy it anyway. This is a topic that I’ve been passionate about for… · sql, server, features, json, post

After a (very) long hiatus from gaming I recently got back into Table Top Role Playing Games (TTRPGs) and it has reignited some of my creative writing as well. Tips, tricks, and stories abound! Come along for the… · devrel, community, section, news, product

Start your SQL learning journey today! · start, sql, learning, journey, today

Hi!, I'm a software engineer and author from London. I've just published my book - Build a Database Server. Learn how real databases like PostgreSQL and MySQL work by building your own database from scratch. Find out… · database, software, engineer, author, london

Graphs, .NET, performance, architecture and everything I stumble upon while writting coding.

SQL Performance Explained: Everything developers need to know about database performance by Markus Winand

Okay so I already posted a round up post for this month. You can see it here. Tonight one of the participants, Rob Farley (Blog | Twitter) made me aware of the fact that I missed a HUGE opportunity in making the round up… · month, power, round, report, share

Author: Gail 20 April 2021 0 Comments I realised the other week, that despite a bunch of posts on indexes over the years, I’ve never written a blog post on Columnstore indexes. Time to fix that. Here’s everything you… · indexes, index, columnstore, page, other

I meant to write this almost a year ago, but then I was asked to take a look at high… It feels like only yesterday I was complaining about Sentinel One trying to take the crown for shittiest security software.… There’s… · take, meant, write, almost, year

Click to read about all of the new updates Click to read about all of the new updates I'm just a guy who enjoys data analytics, spending time with his family and friends, and sports! · click, read, updates, guy, enjoys

On-Disk & In-Memory Pages that teach you the SQL way of life!

Data Analyst well versed in SQL, Python, Tableau. Data Analyst well versed in SQL, Python, Tableau. · data, analyst, well, versed, sql

My random thoughts on SQL. If I can help you do your job better, then I've succeeded in my mission!

Let’s take a deep dive into your SQL Server platform and the infrastructure beneath it. Because in today’s environment, resilience and performance are your competitive edge—and they start with infrastructure that just… · sql, server, performance, infrastructure, systems

Helpful posts about SQL Server, Merge Replication and how to tune your databases for maximum performance. Mostly focusing on C# and JavaScript but I enjoy exploring other languages such as F# and Python. Automation is… · cover, helpful, posts, sql, server

Loading your experience… This won’t take long. · loading, won, take, long

For people who've worked through Mastery with SQL, a common question I get is "What's next?" If you completed the course and all 150+ exercises, at this point you'll have a very strong grasp of SQL and should be… · project, sql, microsoft, teams, app

Paul Turley's Power BI and SQL Server BI Blog: Sharing my experiences with the Microsoft data platform, SQL Server BI, Data Modeling, SSAS Design, Power Pivot, Power BI, SSRS Advanced Design, Power BI, Dashboards & Visualization since 2009

I love small performance optimizations that make a huge difference, such as these two from Bruce Dawson of the Chrome team and formerly of Valve Software. This is the tale of one I found at work in May of this year… · xml, small, performance, future, database

For the last twenty years, I have managed to transform an obsession with PL/SQL into a paying job. How cool is that?

There’s a lot of crap out there when you read about Artificial Intelligence projects, especially on LinkedIn, where I suspect half of the posts may have been created by AI bots. However, we recently implemented a process… · nodes, data, some, were, code

Data community events in Chicago have returned! Do the tools you use make something more or less of an engineering effort? Let's dive into optimized locking in Azure SQL Database! · data, make, let, community, events

"I am a Data Scientist, Software Developer, Big Data Architect and Entrepreneur." · data, scientist, software, developer, big

I was talking to a friend of mine and they are learning some SQL and they said something that I have seen come up multiple times in learning SQL. They said “Yeah, I need to study the join types more. They make sense to… · sql, join, right, joins, learning

I wanted to dedicate my first blog post to the most beautiful data I believe there is. So, while filtering the ideas in my head, I couldn’t help but notice that a specific one was immediately pinned right at the top of… · data, beautiful, blackjack, games, strategy

A blog about all things PowerShell, SQLBits, Community, dbatools, dbatoolsMoL, dbachecks, Azure, SQL, PSConfEU and more

Finally got around to updating my CV - I left Datasite just before Christmas last year to be a data science consultant with NTT DATA. If you're interested, this is… If we could automatically pull any information from the… · document, know, data, could, even

Ewald Cress's SQL Server blog. Various explorations of internals for curious folks.

Working in a technical field has it’s ups and downs. One of the more common annoyances I run into is people that can either not explain what they mean in simple terms or that choose not to in order to appear… · page, fill, factor, data, row

Indexes can be easy. I promise.

After a career of spanning 20+ years as a generalist in tech, I wanted to create a blog to focus specifically on my adventures in the data realm. I started programming early on by creating an address book using Access… · sql, server, data, database, administration