DBTA – Big News in the Microsoft Cloud

If you've used Azure in the past, you probably know that there are two main ways to deploy SQL Server on Microsoft's cloud—Azure SQL Database, the PaaS offering; and Azure VMs running SQL Server. Microsoft is now offering a third deployment option in preview which provides full SQL Server engine capability, including SQL Agent, along with native VNet support. Click HERE to read more … [Read more...]

DBTA – Surprising but True: The Basics are Still Difficult

I always look forward to new research from Unisphere Research, a division of Information Today, Inc., publishers of this magazine and other great products for data professionals. The latest report which you should read is "SQL Server Transformation: Toward Agility & Resiliency 2017; PASS Database Management Survey." Click HERE to read more … [Read more...]

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...]