(Joe Celko) In theory, it is easy to determine whether data is equal to, greater than or lesser than a value. Real-world data types can be surprisingly tricky, even for gauging data equivalence. Because SQL cannot remain aloof from any application’s data types, you need to be aware of the ways and p

(Pinal Dave) I try to keep the understanding and concepts for learning simple. Because for a strong building one needs to have a solid foundation. The structure’s stability is a function of how well the foundation holds them. Just having a beautiful exterior will not be sufficient.

(Hannes du Preez) The following query shows the last time a full backup was taken on a certain database.

(Mahesh Sabnis) RDBMS have held the bulk of the world’s enterprise data for over three decades now. For developers working on the Microsoft stack, SQL Server is clearly the de facto relational database server of choice.

(Jeremy Kadlec) SQL Server is mission critical for our organization. We have adopted SQL Server Availability Groups to meet our high availability and disaster recovery needs to support the business requirements.

(Pinal Dave) Solving puzzle is something everyone would love to do. It gets our creative thoughts and the things that it challenges how we can solve problems.

(Daniel Mellor) Today I’d like to share a quick script that is useful when working with a new domain of SQL servers. It’s also good for anyone who doesn’t know their environment very well or suspects there might be some hidden or rarely used servers.

(Kenneth Fisher) I love this somewhat obscure mathematical operator. All it does is return the remainder of a division statement but even though it’s pretty basic most people I talk to have never heard of it.

(Fikrat Azizov) SQL Server 2012 is known for a few amazing performance features and columnstore index is one of them. According to Microsoft, this new type of index can bring up to a 10x performance improvement for certain queries and is recommended for large data warehouse and real time operational

(Artemakis Artemiou) How do you go about transferring a disk-based workload to the respective memory-optimized design? How do you process memory-optimized tables? How important for performance are natively-compiled Stored Procedures?