DBTA – WIT and the SQL Server Community

Women's issues have headlined the news media for the past several months. Many stories, ranging from the #MeToo movement to the "Brogrammer" email blast at Google, have shown that women in technology (WIT) face negative work conditions and social pressures. In light of that, it seemed appropriate to dive into the topic of WIT within the SQL Server community (aka, the Data Platform community) and gauge where we're at. Click HERE to read more … [Read more...]

DBTA – SQL Server Drill Down – Fly to the Cloud Using the Azure Database Migration Service (DMS)

On August 30, 2018 Microsoft announced the public preview of the Azure Database Migration Service (DMS) to support online migrations of various databases to Azure. What's an "online migration"? Online migration means that your databases remain operational while conducting the migration. This provides quite a few obvious benefits. Click HERE to read more … [Read more...]

DBTA – The New SQL Server Vulnerability Assessment Tool Goes GA

The SQL Server Vulnerability Assessment tool (VA) is a feature within SQL Server Management Server (SSMS) 17.4 that scans your SQL Server instances of version 2012 and later, identifies security issues, and suggests fixes to the vulnerabilities it finds. It works for on-premises SQL Server and Azure SQL Database, whether housed on physical or virtual servers. Click HERE to read more … [Read more...]

History of PASS, Part 3: Bylaws Version 1

Kevin Kline shares the initial PASS Bylaws, how they came to be, what they focused on, and the first rounds of changes that we made to them as a team. Click HERE to read more. … [Read more...]

DBTA – Get to Know Azure SQL Database Hyperscale

About 5,500 of the SQL Server faithful came out for the PASS Summit 2018 in Seattle last November. As usual, the event had the feel of a great big family reunion. It's always a fun time, with lots of socializing in the halls of the conference center and at the various restaurants and gathering places around town. The training was also top-notch this year with more than 16 tracks of sessions going on from early morning until evening—literally hundreds of SQL Server developer, DBA, architect, BI, and data science session. Click HERE to read more … [Read more...]

DBTA – HIPAA: DBAs, Data, and the Law

With all of the hype around data being "the oil of the 21st century" and the rise of "the algorithm economy," it seems reasonable to make it a priority to learn more about how laws affect our lives as DBAs. The first law that I have targeted is probably the best-known data law in the U.S.—HIPAA, the Health Insurance Portability and Accountability Act of 1996. Click HERE to read more … [Read more...]

Expert Q&A: Consolidating Your SQL Server Environment to the Cloud

In this blog post, Kevin Kline answers questions from our webinar “Consolidating Your SQL Server Environment to the Cloud.” Click HERE to read more. … [Read more...]

DBTA – SQL Server Drill Down: Containers and the World of OS-Level Virtualization

If you haven't been paying a lot of attention, you might have missed the rise of a new form of virtualization, based at the operating system level, called "containers." While there are many specific software programs, by far the most prominent is Docker. So, from here on out, consider "Docker" and "container" to be synonymous. Click HERE to read more … [Read more...]

DBTA – SQL Server 2016 is Simply Faster… A Lot Faster

I had the pleasure to spend some time with my old friend Mark Souza, a general manager in the Data Platform team at Microsoft, while speaking at the SQL Saturday event in Dublin, Ireland. Now keep in mind that Mark and I have known each other since the 1990s when SQL Server was just being ported to a brand new operating system called Windows NT. Mark and I were having a laugh and more than a twinge of nostalgia about how much SQL Server has improved over the decades and now sits atop the heap on most analysts' "best database" reports. This isn't just two old-timers sharing a few war stories … [Read more...]

Consolidating Your SQL Server Environment On-Premises: Q&A

In this blog post, we answer questions from our webinar “Consolidating Your SQL Server Environment On-Premises.” Click HERE to read more. … [Read more...]