The PowerShell community is a treasure trove of amazing modules and scripts that you can find online and use in your day-to-day operations. It doesn't matter the platform or the purpose, there is ...

T-SQL (Transact-SQL) is a set of programming extensions from Sybase and Microsoft that add several features to the Structured Query Language (SQL), including ...

This book aims to improve your SQL queries using design patterns, how does it fare? The book contains a wide range of topics, supposedly held together by design patterns and best practices. Design ...

Many considerations go into evaluating whether it is time to implement an upgrade to a new version of SQL Server. You need to think about socket vs. core licensing ...

Planning a SQL Server migration can be challenging. From minimizing downtime and protecting data integrity to ensuring application compatibility and maintaining performance, every stage requires ...

Russell Smith is a technology consultant and trainer specializing in management and security of Microsoft server and client technologies. He is a Microsoft Certified Systems Engineer with more than 15 ...

Running SQL Server in the cloud can give users of the database software more flexibility and scalability than on-premises deployments offer -- and maybe save them some money, too. But things often go ...

JSON is a very common method of describing data, in many ways it is a successor to the often much wordier XML. The basics of JSON are discussed, describing its 2 main components: Objects and Arrays, ...