Q&A for database professionals who wish to improve their database skills and learn from others in the community

I haven’t been able to do much coding this year, and my blogging frequency has also decreased dramatically. The reason for this is we bought an old crappy house, tore it down, and then built a new one. Almost all of my… · software, tdd, continue, reading, house

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

T-SQL Tuesday is a monthly blog party hosted by a different community member each month. This month, Mike Walsh (blog) asks us: Write two short notes to yourself. One to the past. One from the future. Thank you for… · blog, community, summit, data, month

This is the announcement blogpost and this is my overview taken from medium: There are many things that makes me happy. Puppies (see picture), food, wine and databases… (not particularly in that order). And things that… · cloud, sql, mysql, things, databases

Writing SQL is fun, but it can be frustrating. One of them is encountering NULL, and you might frown and think, “this is not what I want.” If you have such time, I hope this “Deep Dive with Null of SQL” will help you… · transforms, sql, merge, join, part

Esta es probablemente la pregunta del millón, ya que implica un doble cambio en el nombre de la base de datos (se introduce la palabra AI y se cambia de 23 a 26), un cambio en la numeración de los releases (que vamos a… · database, versión, oracle, por, que

Blog sobre o mundo SQL Server, sobre o produto, ferramentas e soluções que facilitam a vida do DBA no dia-a-dia.

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 & Administration experience with Medical Billing, Start up & Financial Companies Microsoft® Certified Solutions Expert: Data Management and Analytics (SQL Server 2012/2014) Microsoft® Certified Solutions Expert: Data Platform (SQL Server 2012/2014)

I want to talk about a comonad that came up at work the other day. Actually, two of them, as the data structure in question is a comonad in at least …

Welcome to my blog where I ramble on about PostgreSQL and other random things… Welcome to my blog where I ramble on about PostgreSQL and other random things… · welcome, blog, ramble, postgresql, other

Tracy Boggiano's SQL Server Blog concentrating on automation and performance tuning.

I was making a programming language but I’m not anymore but maybe I will again. Wrapping SQLKit for fun and absolutely no profit Keep a SwiftData model up to date. · making, programming, language, anymore, maybe

Introduction This blog aims beginners on how easily they can learn SQL Server step by step. We are trying to cover most of the topics in a simple way with lots of examples and necessary explanations. Hope you will enjoy this series and feel free to share the feedback in comment section. Audience This tutorial…

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

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

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

SQL Server forums

SQL Serverの文字列の大小比較、公式ドキュメントに明記されてないっぽい？ので一部調べてまとめてみました。 社内Wikiに載せたものを公開します。 間違っていたり、不足している内容があるかもしれません。もしございましたら指摘いただけると大変助かります。 yt3trees 2022-05-30 21:54 読者になる · iosevka, sql, server, wiki, yt3trees

テーブルは、データベースにデータを格納するための重要なオブジェクトです。 SQL Server では、以下の手順に従って新しいテーブルを作成することができます。 新しいテーブルを作成するには、CREATE TABLE文を使用します。例えば、以下のように記述します。 上記の例では、PurchaseOrderDetail という名前の新しいテーブルを作成しています。テーブルには、PurchaseOrderID 列からDueDate… · int, sql, server, datetime, 147

Note to self, just in case I mess up a zones’s SOA records’s serial again: Reset the serial number of a DNS zone Posted in Geek, Tech by Thilo-Alexander Ginkel While the ThinkPad T440p is a pretty nice device (and… · touchpad, serial, posted, tech, thilo

MicrosoftテクノロジであるSQLServerのコミュニティです♪ Powered by Hugo. Theme by TechDoc. Designed by Thingsym. MicrosoftテクノロジであるSQLServerのコミュニティです♪ · microsoft, sqlserver, powered, hugo, theme

Celebrating SQL PASS 2O year.. Happy birthday PASS Happy birthday ⁦⁦⁦@sqlpass⁩ from #SqlSatTampa !! #PASSturns20 ⁦⁦@Vishal_BI⁩ always great catching up with you! #SqlFamily pic.twitter.com/4cE67YJWzs — Cecilia Brusatori… · com, https, twitter, pass, happy

I like fast databases. Naturally, this puts me at odds with GUIDs. Alas, developers like to use them, sometimes for good reasons (“we need ids generated on different servers to be unique”) and often for bad (“what if we… · guids, like, run, bigints, columnstore

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

動的計画法 (DP): モデルが既知ならベルマン方程式を繰り返し適用して解ける TD学習 (Temporal-Difference): 1ステップごとにベルマン方程式を近似更新 → 向き: 小規模な環境（例: Grid World, 棋譜の一部など） · temporal, difference, grid, world, atari

Welcome to my blog where I ramble on about PostgreSQL and other random things… Welcome to my blog where I ramble on about PostgreSQL and other random things… · welcome, blog, ramble, postgresql, other

The call for speakers is open! We’re always excited to have experienced and past speakers return (Rob Volk!), but if you’re a first time or relatively new speaker just a note that we’d be thrilled to have you join us… · year, event, back, had, traffic

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

This is part 2 of a series of posts discussing the particulars and as the title says, confusing bits of AQL. Part 1 is here. I’m hoping to discuss what choices implementers of clinical data query language designers have… · query, aql, data, openehr, part

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

Blogs for SQL and database management. SSIS SSRS PowerBI PowerApps

Welcome to the Baltimore SQL Server User Group. We meet monthly to learn about Microsoft SQL Server. Visit our Meetup site to get the details on our upcoming meetings: Content from our meetings is available for download… · sql, server, workday, user, used

I can’t seem to write any personal blog posts, but I did write a 484 page book! Oh well, life goals 🙂 “The journey of a thousand miles begins with a single step.” – Lao-tzu I can’t seem to write any personal blog posts… · write, seem, personal, blog, posts

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

何年か SQL を業務で書いてきたが、しっかり勉強したことがなかった。中級者レベルの自負。 世界一流エンジニアの思考法 (文春e-book) を読んで、脳の負荷を下げるために基礎を再構築したかった。また、レベルの高い技術書の積本を崩すための基礎づくりでもある。 SQL の基本的な操作から始まり、単純な CRUD で使われるような SQL… · sql, select, count, distinct, customer

There’s a few things that I’ve been putting off (for awhile now) on the infrastructure I use to host this site, and it’s come to a point where I need to actually do so; one arduous task being moving the directory that… · some, sql, azure, ads, site

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

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

Author:SQL 長野県を拠点に活動するクイズサークルです。2008年9月に発足しました。SNSmixiX(旧Twitter)2020年2月24日に開設しました。例会参加希望はコチラ例会に参加を希望される方は、こちらのメールフォームから御連絡ください。（フォームが開きます）SQL加入希望・お問い合わせ（フォームが開きます）SQL… · sql, quiz, lovers, author, 2008

Tracy Boggiano's SQL Server Blog concentrating on automation and performance tuning.

This blog is about SQL Server, Azure, Analytics, Data Integration, Data Warehousing, IoT and Business Intelligence.

SQLRod - Tales, experiences and carnage from a lifetime lurker of the SQL Server pit.

“Stay hungry. Stay foolish.” – Steve Jobs Day 2 kicked off with Matt Garman’s keynote, and he opened with a quote that instantly stood out as my favorite of the day “Is it possible? …..Why not! “… Day 1 is an absolute… · sql, server, day, stay, possible