Is the network your last performance bottleneck?
Let’s say your company relies on the cloud for its servers (or maybe not, on premise networks have more options...
2016-07-18
424 reads
Let’s say your company relies on the cloud for its servers (or maybe not, on premise networks have more options...
2016-07-18
424 reads
Fair warning, this is a discussion piece. I had a task, I went through several possibilities and I’m going to...
2016-07-14
978 reads
It’s Chris Yates (b/t) birthday! (I think he just tured 19.) And in honor of his birthday we are writing...
2016-07-12
740 reads
Foreign keys are a classic method of enforcing RI (Referential Integrity). Unfortunately though, they can get in the way if...
2016-07-11 (first published: 2016-06-29)
1,944 reads
Steve Jones (b/t) has been asking people to post their Pass Summit submissions and the reviews that came back, along...
2016-07-07
438 reads
Like many other programming languages T-SQL uses parentheses () for a number of tasks. To help determine precedence, function calls etc....
2016-07-05 (first published: 2016-06-27)
2,700 reads
That SSIS change just won’t stick! There is a new business requirement, so now you have to change an existing...
2016-07-05
986 reads
The cloud can be expensive. I had this hammered home the other day by a simple mistake. I’m currently working...
2016-06-27 (first published: 2016-06-20)
1,471 reads
This feature is Enterprise only which can limit who it is useful to, but I find the whole concept fascinating....
2016-06-22
490 reads
This month my friend Michael J Swart(b/t) would like us to talk about the new 2016 version of SQL Server....
2016-06-20 (first published: 2016-06-14)
3,344 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