How many of you are taking full advantage of SQL Server tools? Brad McGehee thinks the answer is "Surprisingly few", and suggests you take the time to learn, and eventually master, the tools which already come with SQL Server.
We all need time to relax and unwind, but what happens if that time is interrupted by a work call? Should you respond? Steve Jones reminds us that you can say no if you are not prepared to work.
We are inundated with new technologies and products designed to help make our organisations safe from hackers and other malcontents. One technology that has gained ground over the past few years is database activity monitoring. It makes sense to protect valuable databases, and by adding an intelligent monitor capable of sniffing out threats an additional level of protection can be gained.
But what is database activity monitoring and why should you care?
The task is to look at the appointments and the recurrence of schedules to come up with a list of meetings for a given period.
If you experiment at all with transactions that are built into SSIS you will discover that they are highly flawed. ...
SQL Server 2008 has a number of enhancements over 2005 that make it a more capable platform. New author Arshad Ali brings us an overview and some code about a few T-SQL changes.
Traveling to Charlotte, NC for SQL Saturday #33, Steve Jones takes a break from writing with a short piece, and quite a few mistakes from this year.
To be able to drill into multidimensional cube data at several levels, you must implement all of the hierarchies on the database dimensions. Then you'll create the attribute relationships necessary to optimize performance. Analysis Services hierarchies offer plenty of possibilities for displaying the data that your business requires. Rob Sheldon continues his series on SQL Server Analysis Services 2008.
Find out what makes Mnesia, the Erlang-based database management system, perfect for distribution across a network of computers.
For the past several weeks, I have been running a poll on www.bradmcgehee.com, asking visitors if they thought that DBAs...
By John
If you’ve used Azure SQL Managed Instance General Purpose, you know the drill: to...
By DataOnWheels
Ramblings of a retired data architect Let me start by saying that I have...
By Steve Jones
A customer was testing Redgate Data Modeler and complained that it auto-generated PK names....
Hi everyone, Below is a consolidated summary of what we validated Architecture & data...
Hi all, I recently moved to a new employer who have their HA setup...
Comments posted to this topic are about the item Semantic Search in SQL Server...
I have this data in a SQL Server 2025 table:
CREATE TABLE Response ( ResponseID INT NOT NULL CONSTRAINT ResponsePK PRIMARY KEY , ResponseVal VARBINARY(5000) ) GOIf I want to get a value from this table that I can add to a URL in a browser, which of these code items produces a result I can use? See possible answers