Kathi Kellenberger introduces the new Estate monitoring pages in SQL Monitor 9, and explains how they will help DBAs monitor and safeguard the security, stability and availability of all servers in their care.
2019-04-18 (first published: 2019-04-08)
Within an instance of SQL Server, the database settings can have a direct effect on the database’s behavior, performance and availability. Sometimes, it is difficult to tie a symptom to a cause, so it is wise to routinely check and record these settings. Before you change the current setting, it pays to understand exactly what it means and the implications of any change.
2011-10-04
3,490 reads
There are many ways to invest in yourself and Steve Jones reminds us of one in today's editorial.
2009-05-13
317 reads
There are many ways to invest in yourself and Steve Jones reminds us of one in today's editorial.
2009-05-12
502 reads
There are many ways to invest in yourself and Steve Jones reminds us of one in today's editorial.
2009-05-12
518 reads
There are many ways to invest in yourself and Steve Jones reminds us of one in today's editorial.
2009-05-12
755 reads
2005-05-27
I doubt it. Try the following to see if making your code reflect these examples more closely helps.http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnproasp/html/usingstoredprocedures.asphttp://msdn.microsoft.com/library/default.asp?url=/library/en-us/adosql/adoprg02_525v.aspI've never used output parameters like this, but it may be that cmd.Parameters("@RETURN_VALUE1") doesn't access the output parameter. It may be in a different collection (I have no idea). The MSDN examples keep using enumerated vs named access. […]
2005-03-21
Hey, I wouldn't use COALESCE unless I really need the extended functionality compared to ISNULL or have to care about portability. Why? Have a play with this snippets.CREATE TABLE #t ( c1 CHAR ) INSERT INTO #t VALUES (NULL) SELECT ISNULL(c1,'Frank') , COALESCE(c1,'Frank') FROM #tSELECT ISNULL(c1,'Frank') , COALESCE(c1,'Frank') ,CASE WHEN c1 IS NULL THEN 'Frank' ELSE […]
2004-11-18
CurrentProject.Name will return the name of the file, or if you have given the application a title in the startup dialog box then currentproject.Properties("AppTitle") will return this
2004-09-23
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
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...
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