How do you secure the SQL Server instance after enabling xp_cmdshell ?
OR
How do you allow non-administrator to use xp_cmdshell ?
From the day I started working with SQL server, I have heard
about...
2012-03-22
4,555 reads
Blog Posts
March #Meme15 Round-up – Facebook
Are you ready for the round-up of last week’s #meme15 Facebook question?
In total, there were eight participants in this month’s...
2012-03-22
1,018 reads
Restore fails with tail of log error
For sql server 2005 and above, When you take a full backup of the FULL recovered database and try to...
2012-03-22
693 reads
RYO Maintenance Plan – History Cleanup
The last step in our campaign to rid the world of maintenance plans deals with housekeeping: the history cleanup step....
2012-03-22
997 reads
2012-03-22
24 reads
SQL Server 2012 Unattended Installation on Windows Server 8
In part 5 will install SQL Server 2012 on 3 Windows Server 8 VM’s using GUI and unattended installation to...
2012-03-22
1,119 reads
2012-03-22
4 reads
2012-03-22
9 reads
2012-03-22
4 reads
Choosing the Right Microsoft Reporting Technology Part 3: PowerPivot
Today I’ll be continuing in a blog series designed to help you decide which presentation tool is best for your...
2012-03-21 (first published: 2012-03-16)
2,954 reads
Blogs
Automated SQL Server Benchmarking with HammerDB and Docker: A Complete Testing Framework
I’m excited to announce the release of a new open-source project that fully automates...
T-SQL Snapshot Backups on Availability Group Secondary Replicas
One of my favourite features of SQL Server 2022 was the T-SQL Snapshot Backups....
The Book of Redgate: Hours
By Steve Jones
I have said and written this many times: Redgate Software is the type of...
Forums
Alamat BCA KCP Iskandar Muda Telp/Wa:0821-8200-233
Hub CS 08218200233 Jl. Sultan Iskandar Muda No.Kav. 80/1-2, RT.2/RW.3, Kby. Lama Utara, Kec....
BCA KCP Panglima Polim Raya Tlp:0821-8200-203
Telp/Wa 628218200203 Ruko Grand Panglima Polim, Jl. Panglima Polim No.16-17, RT.2/RW.1, Pulo, Kec. Kby....
Alamat BCA KCP Kota Kasablanka Tlp/Wa:0821-8200-174
Hub CS 08218200174 1st Floor – Unit B EightyEight@kasablanka, Jl. Raya Casablanca No.Kav. 88,...
Question of the Day
Squared Values
What happens when I run this code in SQL Server 2022?
SELECT SQUARE('12') See possible answers