Spring into the Latest Features at the Luxemborg User Group
The next meeting of the Luxemborg SQL Server User Group has some great sessions planned.
SQL Community
Back in my early days as a database administrator, almost 16 years ago, I happened upon a web site called SQL Server Central. Because I found so many useful articles and forum posts, the site was open in my browser at work every single day. It was a great source of information, and eventually, I […]
How to Programmatically Identify When Your SQL Server Was Last Started
Greg Larsen shows you a quick trick to programmatically script a way to identify when SQL Server was last started.
Keep It All
We could use more intelligence in our backup systems, since we don't need to keep all those files.
Making Deployments Simpler with Re-runnable Scripts
Make sure your SQL Server database release scripts to make life easier.
How to Show the Execution Plan of a Running Query
By looking at a query execution plan, you can determine which steps are used to resolve the query. But what if you just want to find out what the query plans are for only the queries that are currently running?
Do you check your backups?
Backups. Are you confident you can restore? Do you have a process that ensures you can recover your systems? Learn how one system works in the cloud.
SQL Server Graph Databases – Part 2: Querying Data in a Graph Database
Along with Graph Databases, Microsoft has introduced the new MATCH function for querying them. Robert Sheldon explains how to use the new function.
Good Security Needs Layers
A good security system needs layers since our applications and platforms don't exist in a vacuum.
Blogs
Creating a Local Model Chatbot on Windows
By Steve Jones
After my session at VSLive last week, I had a few questions from the...
To refer and to be referred
Referrals have never been more important in the job market. They’re no longer nice...
A New Word: Dorgone
By Steve Jones
dorgone– adj. wondering if you could slip away from an event or group conversation...
Forums
Querying Multiple Tables for the Same Information
I have about 100 Tables that are all suffixed with _Modify. These tables record...
Make It Routine
Comments posted to this topic are about the item Make It Routine
Finding Gaps in Sequential Data Using SQL Server
Comments posted to this topic are about the item Finding Gaps in Sequential Data...
Question of the Day
Negative and Positive Numbers
If I want to know whether a number of negative, positive, or zero, what is the easiest way to get this in T-SQL?
See possible answers