HPE Superdome X FAQs
The HPE Superdome offers several unique features, and here are some FAQs to help you get the most out of them. read more
Learn More with Penton Technology’s New Professional Education Platform
We’re proud to share our new Penton Technology Professional Education platform, which will enrich the online education experience for IT professionals. “Our new education platform allows tech professionals to enhance their career …
What to Do When DBCC CHECKDB Reports Corruption
The instant you encounter corruption in a production SQL Server database, here’s what to do: 1. Query the msdb.dbo.suspect_pages table. This system table tracks up to the last 1,000 corrupt pages detected. This will give you a quick idea of how w …
Redgate DLM Demo (with TFS, TeamCity, Octopus Deploy)
How can Redgate DLM help you improve your database development and deployment processes? Join Grant Fritchey to see a demo of the Redgate DLM tools working with TFS, TeamCity, and Octopus Deploy. You’ll learn how to version control your databases, incl …
A Comparison of JDBC Drivers for MySQL
A brief comparison of three different JDBC Drivers built for connecting with MySQL
Comparing Networking Options in Azure
What are your options for connecting to an Azure VM? Sure, a Remote Desktop Protocol (RDP) connection will get you started but you’ll soon need a full secure VPN connection. Azure can provide three different options for doing this: Point-to-Site (P2S), …
SQL SERVER – Handling XML Documents – Notes from the Field #125
[Note from Pinal]: This is a 125th episode of Notes from the Field series. Handing XML documents is not an easy task. Trust me till today I see lots of experts struggling when they have to deal with XML. In my early career I used to be scared with the …
Extended Events: Where They Hide The Good Stuff
You can do a lot with Extended Events I’m really looking forward to the stuff in 2016 becoming mainstream in 2020 or so. Raise your hand if you’re using SQL Server 2014 in production. Raise your hand if your vendor supports SQL Server 2014. …
SQL Server 2012 Build List
A list of the builds of SQL Server 2012 through SP2 CU11.
Differences between Delete and Truncate in SQL Server
Atul Gaikwad details the differences between DELETE and TRUNCATE, including how they vary in terms of being rolled back.
Stairway to Database Source Control Level 5: Working with Others (Distributed Repository)
This level starts with an overview of how versioning works in Git, a DVCS, and suggests a sensible database project versioning strategy. It then offers some simple, but illustrative, practical examples showing how to share database changes and deal gra …
24 Hours of PASS – Evolution of the Data Platform – The Grand Finale
I am honored that I was selected to present my session « Winning with Column Store: A Customer Story » for the upcoming 24 Hours of PASS event. Details about my session and the 23 other sessions may be found here – http://www.sqlpass.org/Events/24Hoursof …
SQL SERVER 2016 – Management Studio Highlighting Current Line Option
With every new release, there is changes that are being made to the tools that support it. It is tough sometimes to keep up with the pace. I am always an old school guy and I try not to change the style that involves changes to the way things function. …
Data Tales #8: Database on a Diet (Part 3)
Hi Folks, My series of articles for SQL Server Magazine continues. Last time, I continued a short series about a large database that needed to go on a diet. Last time, I look at the internals of row and page compression, to see what happens when they a …
Predictive Analysis Basics
Statistics holds out the promise of teasing out significant relationships and to determine cause and effect. Now that so much data is easily available, does that mean that we can at last harness these techniques to predict future trends and outcomes? F …