(Manoj Pandey) I just started learning SQL Server, and I want to get certified, I checked internet, but I got confused.
Tag: sql server
How Safe Is Your Data From Theft?
(Thomas LaRock) This Tuesday will mark the 45th anniversary of the day that Jerry Neal Schneider became a household name.
SQL: Different ways to generate sequence
(Prashanth Jayaram) There was a question from the op regarding adding a new column to a query output by generating the cyclic sequence numbers from 1 to 3.
SQL Server Compatibility Levels
(Scott Mattie) Have you ever wondered what versions of SQL Server related to the compatibility levels? This article will show you the levels and also how to change existing databases to different SQL releases.
Interactive query experience for SQL databases
(Arun Sirpal) This is a new feature where you can issue TSQL commands via a TSQL editor straight from the Azure portal, why this is great is because sometimes you do not want to keep switching between your SSMS (SQL Server Management Studio) connection and the Azure portal to issue basic commands an
Handling Graphs in SQL
(Joe Celko) Many practical database problems can be tackled more simply and intuitively by graphs or networks, which in this sense are graphs in which attributes can be associated with the nodes and edges. It is a natural way to study relationships within the data. SQL databases aren’t the easiest w
Explaining Activity Monitor
(Tibor Karaszi) This post is not about how to use the Activity Monitor (AM) tool in SQL Server Management Studio (SSMS) – there are loads of such posts written already. Also, it is not about dissing AM, you will find such posts as well.
Generate Permutations Fast using SQL
(Michael J. Swart) If you google “generating permutations using SQL”, you get thousands of hits. It’s an interesting problem if not very useful.
Tying Down the Source Code
(Tony Davis) Database source code analysis can flush out weakly-authenticated database users, over-privileged users and roles, or stored procedure code that concatenates a parameter directly into the dynamic SQL string that is to be executed, and so is vulnerable SQL injection. This is great for the
Solving the Net Changes Problem with Temporal Tables (T-SQL Tuesday #087)
(Adam Machanic) SQL Server 2008 was perhaps not the meatiest of SQL Server releases, but it did have one especially promising feature: Data change detection.