It is important for developers and DBAs to be able to determine the interdependencies of any database object. Perhaps you need to work out what process is accessing that view you want to alter, or maybe find out whether that table-type you wish to change is being used. What are all these dependencies? How do you work out which are relevant? Phil Factor explains.
2015-10-23
3,238 reads
A short editorial explaining the pitfalls of using search engines as reference for DBA's.
2010-08-05
309 reads
Code to create a handy date calendar cross-reference table with a ton of pre-populated, slice-and-dice data field variations to aid in complex date parameterization / selection criteria.
2019-04-15 (first published: 2009-10-06)
15,119 reads
As soon as the distribution agent starts delivering all transactions the log will be clearing but the size won't be reduced.
2005-04-01
Ok. What I am trying to come up is a solution wherein I could setup ReportServer the way that it used to (disallow anonymous access) but if intranet or internet users will access the ReportServer through my application, somehow, the credential part will be bypassed. I could do this with RS Web Service passing the credentials but […]
2004-08-19
I've had issues with moving this before. Instead, the easier solution, IMHO, is to let each person install the client tools on their workstation. Simple, fast, not that large, and works well.There are relatively few updates to BOL, so this shouldn't be a big deal to update everyone.
2004-04-08
Great! Hmm i guess it doesn't match the nulls cause its not "IS NULL"
2004-02-21
Maybe this would work: sp_grantlogin [@loginame =] 'login' sp_grantlogin sp_revokelogin Note that the SQL security account procedures and the NT security account procedures differ. If you got a snapshot of all of the logins/role membership/permissions for the NT accounts, and their NT account name has not changed, then you could scan through them and use […]
2003-12-01
2003-07-27
2003-07-15
3 reads
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
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