If you own a database with encrypted modules but you don't have a decrypted version, this can be a horror story.
Learn how to get back the code of the encrypted modules using dbatools.
2020-08-18
2,510 reads
Paul White discusses the internals of SQL Server's WITH ENCRYPTION clause, and explains why it is not as safe as you might think.
2016-06-14
3,877 reads
this code encrypts all stored procedures that meet a certain format. this code is easy to change to suit your particular needs, but be sure to back up your stored procs first.
2009-09-10 (first published: 2008-11-21)
3,310 reads
Hi, I have to move an entire SQL Server system dbs (and also user databases) from current basic drive W: to new SAN drive H: in cluster server. During the installation, I put Program Files to C: drive and Data Files to W: drive. After move all dbs, we will get rid of drive W. […]
2004-10-14
Not sure about SSWUG (biased as well). PASS conference is a good place to learn and meet people, not sure about the added value of the association. Steve Jones sjones@sqlservercentral.com http://qa.sqlservercentral.com/columnists/sjones www.dkranch.net
2003-06-24
satish, Take a closer look at my earlier query. The DELETE FROM Orders FROM Orders was actually not a typo, although I admit that the SQL syntax in this situation is extremely confusing. Here's your query: DELETE FROM WTRDET FROM WTRDET INNER JOIN ( SELECT Order_NBR ,Line_NBR, MAX(Ship_Date) as MaxShipDate FROM WTRDET GROUP BY Order_NBR […]
2003-06-05
Are you ready to take your SQL skills from theoretical to tactical? If you've...
By Steve Jones
Note: I DO NOT recommend this. Any changes to a pipeline should be in...
By Steve Jones
symptomania – n. the fantasy that there’s some elaborate diagnosis out there that neatly...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers