Full-Text Search – Word Breakers and Stemmers
There are numerous components to the Full-Text Search (FTS) subsystem in SQL Server that help provide efficient, relative answers to...
2013-01-14
4,508 reads
There are numerous components to the Full-Text Search (FTS) subsystem in SQL Server that help provide efficient, relative answers to...
2013-01-14
4,508 reads
The various security scans of 2012 reported lots of potential problems in companies. Why don't vendors make it easier for us to install and configure their software securely?
2013-01-14
79 reads
This week a vulnerability in Java has prompted a large scale notice to the general public.
2013-01-14
166 reads
Is auditing in use in your applications? Steve Jones wants to know as he thinks it will be more important in the future for most software.
2013-01-11
114 reads
What would happen if the wrong patches were applied to your database server? The results could be a huge problem. Steve Jones reminds you to be careful with mass patches.
2013-01-10
147 reads
Brent Ozar Unlimited released v16 of this sp_blitz script, which is designed to run on a SQL Server instance and...
2013-01-10
1,403 reads
A series that looks at the SQLServerCentral database servers using the Brent Ozar Unlimited sp_blitz script. Read about what we learned.
2013-01-10
10,068 reads
I’ve been looking for ways to improve the way I do my job, which is mostly writing and editing, but...
2013-01-09
1,164 reads
Statistical databases contain lots of information that can be used in a variety of ways, but it can also be abused. Steve Jones talks about some of the problems and potential solutions.
2013-01-08
113 reads
It’s T-SQL Time again, and this time it’s #38, from Jason Brimhall (b | t | li). The topic this month is...
2013-01-08
1,192 reads
By Arun Sirpal
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...
By DataOnWheels
This is a blog that I am writing for future me and hopefully it’ll...
By Steve Jones
While wandering around the documentation looking for some Question of the Day topics, I...
Comments posted to this topic are about the item Pro SQL Server Internals
Comments posted to this topic are about the item SQL ART: Who's Blocking Who?...
Comments posted to this topic are about the item Running SQLCMD II
I run this command to start SQLCMD:
sqlcmd -S localhost -E -c "proceed"At the prompt, I type this (the 1> and 2> are prompts):
1> select @@version 2> goWhat happens? See possible answers