400 reputation
315
bio website
location New York, United States
age
visits member for 2 years, 10 months
seen 9 hours ago

SQL Server DBA


Mar
15
awarded  Notable Question
Mar
12
revised Is bulk-logged recovery model ever a good choice if point-in-time restore is not needed?
edited title
Mar
12
asked Is bulk-logged recovery model ever a good choice if point-in-time restore is not needed?
Mar
6
asked Changing the SQL Server service account - any additional considerations?
Jan
30
comment Use @@servername and db_name() on notify operator task
For the server name portion, I recommend changing the DISPLAY NAME in the mail account configuration to include the instance name. For example, all the e-mails from my servers show "[InstanceName] SQL Server Alert" in the FROM column in my mail client. That way there is no confusion regarding what server sent the alert.
Dec
20
awarded  Popular Question
Dec
6
comment How to determine if SQL Server Reporting Services database is being used?
If that logs every report execution, I might be good to go. This table in both ReportServer and ReportServerTempDB are both empty. Perhaps they were never used. You should post your coment as an answer!
Dec
6
asked How to determine if SQL Server Reporting Services database is being used?
Dec
6
comment Why isn't SQL Server using the Max Server Memory setting?
The development team is holding us back! :)
Dec
6
comment Why isn't SQL Server using the Max Server Memory setting?
It's an inherited server, and things are moving off it....slowly.
Dec
6
asked Why isn't SQL Server using the Max Server Memory setting?
Oct
15
comment Downgrading SQL Server 2012 to Lower Edition
That's a shame. There should be an easy way to do this!
Sep
30
comment Multiple versions of SQL Server on the same development machine
Aaron - what version of Windows are you using for that bad boy?
Sep
30
accepted Multiple versions of SQL Server on the same development machine
Sep
30
comment Multiple versions of SQL Server on the same development machine
Great suggestions! Seeing as how you've got so many versions running successfully, perhaps I'll go ahead and add SQL Server 2014 to my new server as well. Thanks!
Sep
30
asked Multiple versions of SQL Server on the same development machine
Sep
30
accepted Max Memory settings on Multi-Instance SQL Server 2008 R2 Cluster
Sep
30
comment Max Memory settings on Multi-Instance SQL Server 2008 R2 Cluster
Nice writeup Aaron! I'm going to try this. What happens if I don't adjust the max memory while I have all 4 instances on the same node? Will the buffer caches quickly spill into the page file? Any way to prevent that other than setting the max?
Sep
25
revised Max Memory settings on Multi-Instance SQL Server 2008 R2 Cluster
added 10 characters in body; edited title
Sep
24
comment Max Memory settings on Multi-Instance SQL Server 2008 R2 Cluster
Yes, I have 4 instances total, 2 per node.