Kevin Kline wraps up SQL Vacation 2018 in Boston. He discusses some of the unique sights to see around town and chats with Andy Mallon, who leads the BostonSQL group. Click HERE to read more … [Read more...]
SQL Vacation 2018: Tech Goes to Work in Burlington, MA
July 16, 2018 by Leave a Comment
SQL Vacation 2018 has reached Burlington, MA! Kevin Kline introduces you to New England SQL Server User Group Leader Vladimir Ivanovich and highlights some must-see attractions in the Burlington area. Click HERE to read more … [Read more...]
SQL Vacation 2018 Takes on the Big Apple
July 12, 2018 by Leave a Comment
While in New York City on SQL Vacation 2018, Kevin Kline shares some fun NYC facts and attractions. He also interviews New York SQL Server Meetup leader Thomas Grohser. Click HERE to read more … [Read more...]
SQL Vacation 2018: It’s Always SQL in Philadelphia
July 10, 2018 by Leave a Comment
On his second SQL Vacation 2018 stop, Kevin Kline interviews Sebastian Meine of the Philadelphia SQL Server User Group (PSSUG) and highlights unique sights to see in Philly. Click HERE to read more … [Read more...]
SQL Vacation 2018: Kick Off in the Capital
July 9, 2018 by Leave a Comment
Kevin Kline shares his recommendations for things to see in Washington D.C. and interviews two local SQL Server community leaders who played an integral role in bringing SQL Vacation 2018 to D.C. Click HERE to read more … [Read more...]
DBTA – Heightened Flexibility for SQL Server Admins with SQL Operations Studio
July 5, 2018 by Leave a Comment
On June 20th, the Microsoft SQL Server team dropped the most recent release of SQL Operations Studio to the public. This is just one of many, many product announcements that demonstrate Microsoft's very serious commitment to interoperability and to meeting the needs of their customers wherever they reside, even if that's outside of the Microsoft ecosystem. One of the hallmarks of SQL Operations Studio, compared to the venerable SQL Server Management Studio, is that it's lightweight and expandable. Click HERE to read more … [Read more...]
DBTA – Big News in the Microsoft Cloud
June 28, 2018 by Leave a Comment
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...]
Announcing SQL Vacation 2018!
June 22, 2018 by Leave a Comment
Kevin Kline is hitting the road again with his family for SQL Vacation 2018! Kevin will be visiting 5 SQL Server user groups in 4 states -- find out if he will be in your neck of the woods. Click HERE to read more … [Read more...]
Quick Tip – Speed a Slow Restore from the Transaction Log
May 16, 2018 by 2 Comments
Here's a quick tip for you: During some restore operations on Microsoft SQL Server, the transaction log redo step might be taking an unusually long time. Depending somewhat on the version and edition of SQL Server you've installed, you may be able to increase performance by tinkering with the readahead performance for the redo operations. To do this, you should use the MAXTRANSFERSIZE parameter of the RESTORE statement. For example, if you set MAXTRANSFERSIZE=1048576, it'll use 1MB buffers. If you change the MAXTRANSFERSIZE, keep an eye on the PerfMon objects for Buffer Manager and … [Read more...]
DBTA – WIT and the SQL Server Community
April 12, 2018 by Leave a Comment
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...]
