Full-Text Search – Stoplists in SQL Server
Full-text search is an interesting subsystem in SQL Server. It allows you to implement searches through a variety of text...
2013-01-07 (first published: 2012-12-31)
6,535 reads
Blog Posts
How I like to learn a t-sql command
Recently I received a security request and realized I wasn’t comfortable in my ability to script out the t-sql commands...
2013-01-07
843 reads
How to move file through FTP by CMD ?
CMD code to upload file direct into root of FTP site of server
@ echo off
REM ******** this batch file is to...
2013-01-07
1,665 reads
I Need Your Vote!
Do your civic duty, and vote today!
Voting is now open for SQLBits, to be held in Nottingham, UK this...
2013-01-07 (first published: 2013-01-03)
1,585 reads
January 2013 – Monthly SQL Server Checklist
Today is the first Monday of 2013. Do you know if your servers are ready to take on the first...
2013-01-07
682 reads
Last Weeks Top 10 “Reading” Links #14
Throughout the week, I like to tweet links to the things that I’ve been reading. Since they all come out through out...
2013-01-07
909 reads
SQL Server – Login Failed, cannot open user default database
Each login in SQL Server has a default database associated with it. When you login to SQL Server context is...
2013-01-07
1,809 reads
SQL Server has encountered % occurence(s) of cachestore flush for the % cachestore (part of plan cache) due to some database maintenance or reconfigure operations
Have you seen this type of an informational message in your SQL errorlog before? If so, then I hope the...
2013-01-07
1,149 reads
SQLBits Public Sessions
If you’re over in the UK, or close to it, you’ve probably heard of SQL Bits even if you haven’t...
2013-01-07 (first published: 2013-01-03)
1,535 reads
SSDT – TSQL Unit testing in multiple environments
Late in December, one the long awaited portions of functionality inside SSDT was released to an eager public, that being...
2013-01-07
1,755 reads
Blogs
RANK() vs DENSE_RANK(): #SQLNewBlogger
By Steve Jones
I haven’t done one of these in awhile, but I saw an article recently...
Using CAT for Testing of Data Agents
In last months one of the scenarios where you can use AI has been...
Are you getting value from your reporting?
By ChrisJenkins
Do you spend so long manipulating your data into something vaguely useful that you...
Forums
Creating JSON II
Comments posted to this topic are about the item Creating JSON II
Engineer Lessons
Comments posted to this topic are about the item Engineer Lessons
Question of the Day
Creating JSON II
On SQL Server 2025, what happens when I run this code:
SELECT JSON_OBJECTAGG( N'City':N'Denver' RETURNING JSON) GOSee possible answers