There is a one day window on my production server opening tomorrow - server
is in dire need of maintenence. Planned are defrags, index rebuilds,
backups, and the trial of a backup software with compression (we have a space
problem as well). Experienced DBA's probably know some items that are
critical to address when this opportunity arises. Please help me with
general suggestions.
Regards,
Jamie
Activities in order of priority:
Caffeine delivery vehicle of choice (coffee, Jolt, Red Bull, Tea)
Backups
Necessary Service Packs and/or Patches to OS
Necessary Service Packs and/or Patches to SQL Server.
More Caffeine
If filegroups need to be reorganized, do so
Add New data files if needed
Defrag data files if needed
Towel to wipe sweat from brow
More caffeine
Rebuild any Indexes needing rebuild
Defrag Indexes
Test New Backup software
Backups
Nearest Pub for Beverage of choice
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"thejamie" <thejamie@.discussions.microsoft.com> wrote in message
news:A973D6AF-ABB8-451E-9A17-5A5492F5D117@.microsoft.com...
> There is a one day window on my production server opening tomorrow -
> server
> is in dire need of maintenence. Planned are defrags, index rebuilds,
> backups, and the trial of a backup software with compression (we have a
> space
> problem as well). Experienced DBA's probably know some items that are
> critical to address when this opportunity arises. Please help me with
> general suggestions.
> --
> Regards,
> Jamie
|||Thanks Arnie. Matches my list. Assures me I'm on track.
Regards,
Jamie
"Arnie Rowland" wrote:
> Activities in order of priority:
> Caffeine delivery vehicle of choice (coffee, Jolt, Red Bull, Tea)
> Backups
> Necessary Service Packs and/or Patches to OS
> Necessary Service Packs and/or Patches to SQL Server.
> More Caffeine
> If filegroups need to be reorganized, do so
> Add New data files if needed
> Defrag data files if needed
> Towel to wipe sweat from brow
> More caffeine
> Rebuild any Indexes needing rebuild
> Defrag Indexes
> Test New Backup software
> Backups
> Nearest Pub for Beverage of choice
> --
> Arnie Rowland, Ph.D.
> Westwood Consulting, Inc
> Most good judgment comes from experience.
> Most experience comes from bad judgment.
> - Anonymous
> You can't help someone get up a hill without getting a little closer to the
> top yourself.
> - H. Norman Schwarzkopf
>
> "thejamie" <thejamie@.discussions.microsoft.com> wrote in message
> news:A973D6AF-ABB8-451E-9A17-5A5492F5D117@.microsoft.com...
>
>
Showing posts with label window. Show all posts
Showing posts with label window. Show all posts
Friday, March 9, 2012
Help - Suggestions on 1 day window for Production Server
There is a one day window on my production server opening tomorrow - server
is in dire need of maintenence. Planned are defrags, index rebuilds,
backups, and the trial of a backup software with compression (we have a spac
e
problem as well). Experienced DBA's probably know some items that are
critical to address when this opportunity arises. Please help me with
general suggestions.
--
Regards,
JamieActivities in order of priority:
Caffeine delivery vehicle of choice (coffee, Jolt, Red Bull, Tea)
Backups
Necessary Service Packs and/or Patches to OS
Necessary Service Packs and/or Patches to SQL Server.
More Caffeine
If filegroups need to be reorganized, do so
Add New data files if needed
Defrag data files if needed
Towel to wipe sweat from brow
More caffeine
Rebuild any Indexes needing rebuild
Defrag Indexes
Test New Backup software
Backups
Nearest Pub for Beverage of choice
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"thejamie" <thejamie@.discussions.microsoft.com> wrote in message
news:A973D6AF-ABB8-451E-9A17-5A5492F5D117@.microsoft.com...
> There is a one day window on my production server opening tomorrow -
> server
> is in dire need of maintenence. Planned are defrags, index rebuilds,
> backups, and the trial of a backup software with compression (we have a
> space
> problem as well). Experienced DBA's probably know some items that are
> critical to address when this opportunity arises. Please help me with
> general suggestions.
> --
> Regards,
> Jamie|||Thanks Arnie. Matches my list. Assures me I'm on track.
--
Regards,
Jamie
"Arnie Rowland" wrote:
> Activities in order of priority:
> Caffeine delivery vehicle of choice (coffee, Jolt, Red Bull, Tea)
> Backups
> Necessary Service Packs and/or Patches to OS
> Necessary Service Packs and/or Patches to SQL Server.
> More Caffeine
> If filegroups need to be reorganized, do so
> Add New data files if needed
> Defrag data files if needed
> Towel to wipe sweat from brow
> More caffeine
> Rebuild any Indexes needing rebuild
> Defrag Indexes
> Test New Backup software
> Backups
> Nearest Pub for Beverage of choice
> --
> Arnie Rowland, Ph.D.
> Westwood Consulting, Inc
> Most good judgment comes from experience.
> Most experience comes from bad judgment.
> - Anonymous
> You can't help someone get up a hill without getting a little closer to th
e
> top yourself.
> - H. Norman Schwarzkopf
>
> "thejamie" <thejamie@.discussions.microsoft.com> wrote in message
> news:A973D6AF-ABB8-451E-9A17-5A5492F5D117@.microsoft.com...
>
>
is in dire need of maintenence. Planned are defrags, index rebuilds,
backups, and the trial of a backup software with compression (we have a spac
e
problem as well). Experienced DBA's probably know some items that are
critical to address when this opportunity arises. Please help me with
general suggestions.
--
Regards,
JamieActivities in order of priority:
Caffeine delivery vehicle of choice (coffee, Jolt, Red Bull, Tea)
Backups
Necessary Service Packs and/or Patches to OS
Necessary Service Packs and/or Patches to SQL Server.
More Caffeine
If filegroups need to be reorganized, do so
Add New data files if needed
Defrag data files if needed
Towel to wipe sweat from brow
More caffeine
Rebuild any Indexes needing rebuild
Defrag Indexes
Test New Backup software
Backups
Nearest Pub for Beverage of choice
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"thejamie" <thejamie@.discussions.microsoft.com> wrote in message
news:A973D6AF-ABB8-451E-9A17-5A5492F5D117@.microsoft.com...
> There is a one day window on my production server opening tomorrow -
> server
> is in dire need of maintenence. Planned are defrags, index rebuilds,
> backups, and the trial of a backup software with compression (we have a
> space
> problem as well). Experienced DBA's probably know some items that are
> critical to address when this opportunity arises. Please help me with
> general suggestions.
> --
> Regards,
> Jamie|||Thanks Arnie. Matches my list. Assures me I'm on track.
--
Regards,
Jamie
"Arnie Rowland" wrote:
> Activities in order of priority:
> Caffeine delivery vehicle of choice (coffee, Jolt, Red Bull, Tea)
> Backups
> Necessary Service Packs and/or Patches to OS
> Necessary Service Packs and/or Patches to SQL Server.
> More Caffeine
> If filegroups need to be reorganized, do so
> Add New data files if needed
> Defrag data files if needed
> Towel to wipe sweat from brow
> More caffeine
> Rebuild any Indexes needing rebuild
> Defrag Indexes
> Test New Backup software
> Backups
> Nearest Pub for Beverage of choice
> --
> Arnie Rowland, Ph.D.
> Westwood Consulting, Inc
> Most good judgment comes from experience.
> Most experience comes from bad judgment.
> - Anonymous
> You can't help someone get up a hill without getting a little closer to th
e
> top yourself.
> - H. Norman Schwarzkopf
>
> "thejamie" <thejamie@.discussions.microsoft.com> wrote in message
> news:A973D6AF-ABB8-451E-9A17-5A5492F5D117@.microsoft.com...
>
>
Monday, February 27, 2012
Help - how to open Report in new browser window?
Hello...
I am struggling with this...but I am getting close.
I am trying to use the Web Service programming interface from my ASP.Net
application. What I am trying to accomplish...is to allow the user to set
some report parameters (date ranges, zip codes, etc). When the user presses
the Run button on my ASP.Net page, I would like to render the report in a new
browser window/page, and with the Toolbar so the user could export to
whatever format that they want. Is this possible?
Thanks for any help...
- DW
The code I am using now is the following..
Dim rptIRIS As Byte() = Nothing
Dim rsIRIS As Secure_SQLRS.ReportingService = New
Secure_SQLRS.ReportingService
rsIRIS.Credentials = New System.Net.NetworkCredential("ME", "Pwd",
"Domain")
rsIRIS.PreAuthenticate = True
Dim rptPath As String = "/WebReports/UserLabels"
Dim rptFormat As String = "HTML4.0"
Dim rptViewerInfo As String = "<DeviceInfo>" & _
"<Toolbar>true</Toolbar>" & _
"<Parameters>false</Parameters>" & _
"<DocMap>true</DocMap>" & _
"<Zoom>100</Zoom>" & _
"</DeviceInfo>"
Dim rptParams(1) As Secure_SQLRS.ParameterValue
Dim paramValue As Secure_SQLRS.ParameterValue = New
Secure_SQLRS.ParameterValue
paramValue.Name = "ProductID"
paramValue.Value = "102"
rptParams(0) = paramValue
paramValue = New Secure_SQLRS.ParameterValue
paramValue.Name = "ZipCode"
paramValue.Value = "12345"
rptParams(1) = paramValue
Dim rptHistoryID As String = Nothing
Dim credentials() As Secure_SQLRS.DataSourceCredentials = Nothing
Dim showHideToggle As String = Nothing
Dim encoding As String
Dim mimeType As String
Dim warnings() As Secure_SQLRS.Warning = Nothing
Dim rptHistoryParams() As Secure_SQLRS.ParameterValue = Nothing
Dim streamIDs() As String = Nothing
Dim rptSessionHdr As Secure_SQLRS.SessionHeader = New
Secure_SQLRS.SessionHeader
rsIRIS.SessionHeaderValue = rptSessionHdr
Try
' execute the report
rptIRIS = rsIRIS.Render(rptPath, rptFormat, rptHistoryID,
rptViewerInfo, rptParams, credentials, _
showHideToggle, encoding, mimeType, rptHistoryParams,
warnings, streamIDs)
rptSessionHdr.SessionId = rsIRIS.SessionHeaderValue.SessionId
Response.Clear()
' set the http headers for the PDF response
HttpContext.Current.Response.ClearHeaders()
HttpContext.Current.Response.ClearContent()
HttpContext.Current.Response.ContentType = "text/html"
HttpContext.Current.Response.AppendHeader("Content-Disposition", _
"filename=""AddressLabels.HTM""")
' send the byte array containing the report as a binary response
HttpContext.Current.Response.BinaryWrite(rptIRIS)
HttpContext.Current.Response.End()
Catch ex As Exception
Finally
End TryYou won't be able to accomplish this with straight SOAP interfaces. You will
have to use a combination of Web service calls to list the reports in the
namespace and then a URL request to the server that includes the
parameterized URL for the report. You can certainly open it in a new browser
window under those conditions.
--
Bryan Keller
Developer Documentation
SQL Server Reporting Services
A friendly reminder that this posting is provided "AS IS" with no
warranties, and confers no rights.
"dw" <dw@.discussions.microsoft.com> wrote in message
news:08CC0691-B2A2-4F4C-A1DA-7DAB23E67F20@.microsoft.com...
> Hello...
> I am struggling with this...but I am getting close.
> I am trying to use the Web Service programming interface from my ASP.Net
> application. What I am trying to accomplish...is to allow the user to set
> some report parameters (date ranges, zip codes, etc). When the user
presses
> the Run button on my ASP.Net page, I would like to render the report in a
new
> browser window/page, and with the Toolbar so the user could export to
> whatever format that they want. Is this possible?
> Thanks for any help...
> - DW
> The code I am using now is the following..
> Dim rptIRIS As Byte() = Nothing
> Dim rsIRIS As Secure_SQLRS.ReportingService = New
> Secure_SQLRS.ReportingService
> rsIRIS.Credentials = New System.Net.NetworkCredential("ME", "Pwd",
> "Domain")
> rsIRIS.PreAuthenticate = True
> Dim rptPath As String = "/WebReports/UserLabels"
> Dim rptFormat As String = "HTML4.0"
> Dim rptViewerInfo As String = "<DeviceInfo>" & _
> "<Toolbar>true</Toolbar>" & _
> "<Parameters>false</Parameters>" & _
> "<DocMap>true</DocMap>" & _
> "<Zoom>100</Zoom>" & _
> "</DeviceInfo>"
>
> Dim rptParams(1) As Secure_SQLRS.ParameterValue
> Dim paramValue As Secure_SQLRS.ParameterValue = New
> Secure_SQLRS.ParameterValue
> paramValue.Name = "ProductID"
> paramValue.Value = "102"
> rptParams(0) = paramValue
> paramValue = New Secure_SQLRS.ParameterValue
> paramValue.Name = "ZipCode"
> paramValue.Value = "12345"
> rptParams(1) = paramValue
> Dim rptHistoryID As String = Nothing
> Dim credentials() As Secure_SQLRS.DataSourceCredentials = Nothing
> Dim showHideToggle As String = Nothing
> Dim encoding As String
> Dim mimeType As String
> Dim warnings() As Secure_SQLRS.Warning = Nothing
> Dim rptHistoryParams() As Secure_SQLRS.ParameterValue = Nothing
> Dim streamIDs() As String = Nothing
> Dim rptSessionHdr As Secure_SQLRS.SessionHeader = New
> Secure_SQLRS.SessionHeader
> rsIRIS.SessionHeaderValue = rptSessionHdr
> Try
> ' execute the report
> rptIRIS = rsIRIS.Render(rptPath, rptFormat, rptHistoryID,
> rptViewerInfo, rptParams, credentials, _
> showHideToggle, encoding, mimeType, rptHistoryParams,
> warnings, streamIDs)
> rptSessionHdr.SessionId = rsIRIS.SessionHeaderValue.SessionId
> Response.Clear()
> ' set the http headers for the PDF response
> HttpContext.Current.Response.ClearHeaders()
> HttpContext.Current.Response.ClearContent()
> HttpContext.Current.Response.ContentType = "text/html"
> HttpContext.Current.Response.AppendHeader("Content-Disposition", _
> "filename=""AddressLabels.HTM""")
> ' send the byte array containing the report as a binary response
> HttpContext.Current.Response.BinaryWrite(rptIRIS)
> HttpContext.Current.Response.End()
> Catch ex As Exception
> Finally
> End Try
I am struggling with this...but I am getting close.
I am trying to use the Web Service programming interface from my ASP.Net
application. What I am trying to accomplish...is to allow the user to set
some report parameters (date ranges, zip codes, etc). When the user presses
the Run button on my ASP.Net page, I would like to render the report in a new
browser window/page, and with the Toolbar so the user could export to
whatever format that they want. Is this possible?
Thanks for any help...
- DW
The code I am using now is the following..
Dim rptIRIS As Byte() = Nothing
Dim rsIRIS As Secure_SQLRS.ReportingService = New
Secure_SQLRS.ReportingService
rsIRIS.Credentials = New System.Net.NetworkCredential("ME", "Pwd",
"Domain")
rsIRIS.PreAuthenticate = True
Dim rptPath As String = "/WebReports/UserLabels"
Dim rptFormat As String = "HTML4.0"
Dim rptViewerInfo As String = "<DeviceInfo>" & _
"<Toolbar>true</Toolbar>" & _
"<Parameters>false</Parameters>" & _
"<DocMap>true</DocMap>" & _
"<Zoom>100</Zoom>" & _
"</DeviceInfo>"
Dim rptParams(1) As Secure_SQLRS.ParameterValue
Dim paramValue As Secure_SQLRS.ParameterValue = New
Secure_SQLRS.ParameterValue
paramValue.Name = "ProductID"
paramValue.Value = "102"
rptParams(0) = paramValue
paramValue = New Secure_SQLRS.ParameterValue
paramValue.Name = "ZipCode"
paramValue.Value = "12345"
rptParams(1) = paramValue
Dim rptHistoryID As String = Nothing
Dim credentials() As Secure_SQLRS.DataSourceCredentials = Nothing
Dim showHideToggle As String = Nothing
Dim encoding As String
Dim mimeType As String
Dim warnings() As Secure_SQLRS.Warning = Nothing
Dim rptHistoryParams() As Secure_SQLRS.ParameterValue = Nothing
Dim streamIDs() As String = Nothing
Dim rptSessionHdr As Secure_SQLRS.SessionHeader = New
Secure_SQLRS.SessionHeader
rsIRIS.SessionHeaderValue = rptSessionHdr
Try
' execute the report
rptIRIS = rsIRIS.Render(rptPath, rptFormat, rptHistoryID,
rptViewerInfo, rptParams, credentials, _
showHideToggle, encoding, mimeType, rptHistoryParams,
warnings, streamIDs)
rptSessionHdr.SessionId = rsIRIS.SessionHeaderValue.SessionId
Response.Clear()
' set the http headers for the PDF response
HttpContext.Current.Response.ClearHeaders()
HttpContext.Current.Response.ClearContent()
HttpContext.Current.Response.ContentType = "text/html"
HttpContext.Current.Response.AppendHeader("Content-Disposition", _
"filename=""AddressLabels.HTM""")
' send the byte array containing the report as a binary response
HttpContext.Current.Response.BinaryWrite(rptIRIS)
HttpContext.Current.Response.End()
Catch ex As Exception
Finally
End TryYou won't be able to accomplish this with straight SOAP interfaces. You will
have to use a combination of Web service calls to list the reports in the
namespace and then a URL request to the server that includes the
parameterized URL for the report. You can certainly open it in a new browser
window under those conditions.
--
Bryan Keller
Developer Documentation
SQL Server Reporting Services
A friendly reminder that this posting is provided "AS IS" with no
warranties, and confers no rights.
"dw" <dw@.discussions.microsoft.com> wrote in message
news:08CC0691-B2A2-4F4C-A1DA-7DAB23E67F20@.microsoft.com...
> Hello...
> I am struggling with this...but I am getting close.
> I am trying to use the Web Service programming interface from my ASP.Net
> application. What I am trying to accomplish...is to allow the user to set
> some report parameters (date ranges, zip codes, etc). When the user
presses
> the Run button on my ASP.Net page, I would like to render the report in a
new
> browser window/page, and with the Toolbar so the user could export to
> whatever format that they want. Is this possible?
> Thanks for any help...
> - DW
> The code I am using now is the following..
> Dim rptIRIS As Byte() = Nothing
> Dim rsIRIS As Secure_SQLRS.ReportingService = New
> Secure_SQLRS.ReportingService
> rsIRIS.Credentials = New System.Net.NetworkCredential("ME", "Pwd",
> "Domain")
> rsIRIS.PreAuthenticate = True
> Dim rptPath As String = "/WebReports/UserLabels"
> Dim rptFormat As String = "HTML4.0"
> Dim rptViewerInfo As String = "<DeviceInfo>" & _
> "<Toolbar>true</Toolbar>" & _
> "<Parameters>false</Parameters>" & _
> "<DocMap>true</DocMap>" & _
> "<Zoom>100</Zoom>" & _
> "</DeviceInfo>"
>
> Dim rptParams(1) As Secure_SQLRS.ParameterValue
> Dim paramValue As Secure_SQLRS.ParameterValue = New
> Secure_SQLRS.ParameterValue
> paramValue.Name = "ProductID"
> paramValue.Value = "102"
> rptParams(0) = paramValue
> paramValue = New Secure_SQLRS.ParameterValue
> paramValue.Name = "ZipCode"
> paramValue.Value = "12345"
> rptParams(1) = paramValue
> Dim rptHistoryID As String = Nothing
> Dim credentials() As Secure_SQLRS.DataSourceCredentials = Nothing
> Dim showHideToggle As String = Nothing
> Dim encoding As String
> Dim mimeType As String
> Dim warnings() As Secure_SQLRS.Warning = Nothing
> Dim rptHistoryParams() As Secure_SQLRS.ParameterValue = Nothing
> Dim streamIDs() As String = Nothing
> Dim rptSessionHdr As Secure_SQLRS.SessionHeader = New
> Secure_SQLRS.SessionHeader
> rsIRIS.SessionHeaderValue = rptSessionHdr
> Try
> ' execute the report
> rptIRIS = rsIRIS.Render(rptPath, rptFormat, rptHistoryID,
> rptViewerInfo, rptParams, credentials, _
> showHideToggle, encoding, mimeType, rptHistoryParams,
> warnings, streamIDs)
> rptSessionHdr.SessionId = rsIRIS.SessionHeaderValue.SessionId
> Response.Clear()
> ' set the http headers for the PDF response
> HttpContext.Current.Response.ClearHeaders()
> HttpContext.Current.Response.ClearContent()
> HttpContext.Current.Response.ContentType = "text/html"
> HttpContext.Current.Response.AppendHeader("Content-Disposition", _
> "filename=""AddressLabels.HTM""")
> ' send the byte array containing the report as a binary response
> HttpContext.Current.Response.BinaryWrite(rptIRIS)
> HttpContext.Current.Response.End()
> Catch ex As Exception
> Finally
> End Try
Subscribe to:
Posts (Atom)