THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |


You searched for the word(s):
Showing page 1 of 12 (113 total posts) < 1 second(s)
  • re: The SQL Hall of Shame

    I haven't seen &quot;Managed backups&quot; on this list. It needs at least standard edition, so isn't serving express edition consumers. Especially since maximum retention period is 30 days.
    Posted to Adam Machanic (Weblog) by ALZDBA on June 19, 2017
  • re: A Couple of Invoke-SQLCMD Issues

    @Greg : how about this work around ? import-module -name SQLPs -DisableNameChecking | out-null # MODIFY ######## $SQLInstance = 'yourServer\yousInstance' $ApplicationName = &quot;DBA_Test_ApplicationName&quot;; # Ready to rumble $SMOConnection = New-Object (&quot;Microsoft.SqlServer.Management.Smo.Server&quot;) $SQLInstance ; #Oh please ...
    Posted to Allen White (Weblog) by ALZDBA on June 3, 2015
  • re: SQL Server 2014 Cumulative Update #6 is available!

    Tested install on my laptops dev eddition. Install went fine, but scratching head after instance startup : 2015-02-17 09:31:13.47 spid28s &nbsp; &nbsp; CHECKDB for database 'AdventureWorks' finished without errors on 2013-08-18 12:00:04.847 (local time). This is an informational message only; no user action is required. 2015-02-17 09:31:14.56 ...
    Posted to Aaron Bertrand (Weblog) by ALZDBA on February 17, 2015
  • re: Determining the Windows Groups for a SQL Server Login

    Great script ! You may want to add &quot;and principal_id &lt;&gt; 0&quot; so it filters only the granted windows groups. Johan
    Posted to Greg Low (The Bit Bucket: IDisposable) (Weblog) by ALZDBA on November 4, 2014
  • re: Give speakers feedback. It makes a difference.

    Great feedback processing, Hugo. I attended that session and enjoyed it very much. Whatever you do and however you rework it, please keep the last comparison of the queries as they used to be (especially the SQL2000 one !) and how the over-clause(-evolution) simplifies it all ! Johan
  • re: Snap All the Things!

    Hi Merrill, Nice Script. However, since more and more DBA are no longer Windows Admins on the SQL boxes ( :-( &nbsp;) , how about using only SQLPs to fulfill the quest ? # Loop over databases on the instance &nbsp; &nbsp;$_.FileGroups | % { $_.Files | select Name, FileName } | % { &nbsp; &nbsp; &nbsp; &nbsp;# Loop over the data files in ...
    Posted to Merrill Aldrich (Weblog) by ALZDBA on September 4, 2014
  • re: Choosing SEQUENCE instead of IDENTITY? Watch your step.

    Great find ! Thank you for sharing it !
    Posted to Maria Zakourdaev (Weblog) by ALZDBA on September 4, 2014
  • re: Organize Those Holiday Photos with PowerShell

    Nice script, Merrill. It shows how you might do it the easy way. However, it lacks to use the picture property &quot;date taken&quot;, which is available using .Net properties in System.Drawing. The script in this reference uses this property information, which will even make your photo library more ...
    Posted to Merrill Aldrich (Weblog) by ALZDBA on February 22, 2014
  • re: Troubleshooting Error 18456

    I noticed a Error: 18456, Severity: 14, State: 11 Login failed for user 'domain\account'. Reason: Token-based server access validation failed with an infrastructure error. Check for previous errors. [CLIENT:] ( SQL2008R2 sp2 CU4 on win2008R2 ) Turns out this login didn't have any auth to get to this sql ...
    Posted to Aaron Bertrand (Weblog) by ALZDBA on February 3, 2014
  • re: Ultimate query tuning

    Great post, Rob. I just feel the need to emphasize the needed SET options when working with filtered indexes, as these settings a mandatory for all connections hitting that table. So not only at create time of the index ! ( bol/technet weren't clear on this : ) Been bit by it once ( on ...
    Posted to Rob Farley (Weblog) by ALZDBA on August 23, 2013
1 2 3 4 5 Next > ... Last »
Privacy Statement