Installing SQLCMD
For anyone who wasn’t aware SQLCMD is a command line tool for running T-SQL statements and scripts. Before anyone says...
2016-10-19
729 reads
For anyone who wasn’t aware SQLCMD is a command line tool for running T-SQL statements and scripts. Before anyone says...
2016-10-19
729 reads
A while ago I talked about Templates. This is an easy way to get a, well, template of a piece...
2016-10-17
458 reads
Indexes are great. They speed up our queries. In fact, without them relational database systems wouldn’t work.
Different indexes work best...
2016-10-13
569 reads
My friend Andy Mallon (b/t) is hosting T-SQL Tuesday this month. In case you aren’t aware T-SQL Tuesday is a...
2016-10-11
415 reads
It’s funny how easy it is to find information you aren’t looking for. A few weeks back Stephen Bennett (b)...
2016-10-10 (first published: 2016-09-27)
2,006 reads
I saw an interesting question today about rounding. Specifically they always wanted to round down. Now as it happens that...
2016-10-05
617 reads
A while back I wrote a post on everything I knew about identity columns. In it I mentioned the following:
Negative...
2016-10-03 (first published: 2016-09-21)
2,028 reads
I was awarded the Microsoft MVP (data platform) award on Saturday.
On the four days a year (one per quarter) when...
2016-10-03
630 reads
Data types are an important part of how tables and variables work. Did you know that constants have databases too?
2016-10-03
1,641 reads
As I work on my speaking skills one of my tasks is improve my PowerPoint presentations. To that end I’ve...
2016-09-26
598 reads
By Steve Jones
The season 1, seventh episode of Simple Talks is out. Check it out, with...
By Steve Jones
the McFly Effect – n. the phenomenon of observing your parents interact with people...
At a recent conference I was asked how I executed code during my presentation....
Invoke-Sqlcmd -Query "ALTER AVAILABILITY GROUP $AAG REMOVE DATABASE $DB " -ServerInstance $Instance Invoke-Sqlcmd :...
I assume SSMS V20 encryption and SQL Server SSL encryption are different. I have...
Comments posted to this topic are about the item Enable a Disabled Index
I have disabled the LoggerCI index on the dbo.Logger table. How do I enable it?
See possible answers