Thursday, September 12, 2013

[SQL 2012] Selectively insuring encryption on a connection

[SQL 2012] Selectively insuring encryption on a connection

Selectively insuring encryption on a connection

Posted: 12 Sep 2013 02:34 AM PDT

I have several machines at AWS EC2 and would like to insure connections coming in from the outside are encrypted. I have many application servers at EC2 that are on the same subnet as the SQL Server and do not want to have the overhead of encryption on those connections. On the other hand I have developers and reports accessing the server over the internet and would like to make sure those connections are encrypted. I was trying to come up with a way to poll the connections and forcible close those that are external to the network and are not encrypted. Any ideas?

file copy

Posted: 11 Sep 2013 09:28 PM PDT

I copied a 200 GB backup file from one server to another. I started this at 3 PM yeasterday when I checked it this morning it shows same size in the destination folder. when I checked its properties the size and size on disk shows the same.Do I consider this as a successful copy or in case if the copy was failed in between how would I check it?Thanks.

capture the cpu & memory details store into excel sheet

Posted: 11 Sep 2013 10:26 PM PDT

HI,how to capture the cpu & memory details through powershell and store the results into excel sheet.Advanced Thanks!!!Regards,raj

running sql 2012 and sql 2008 on same server

Posted: 11 Sep 2013 09:17 PM PDT

Hi,our client to want to install both csql 2008 and sql 2012 on same windows cluster.IS It possibility of running SQL 2008 and SQL 2012 on the same windows cluster ?Is it recommaned tohave both version on same servers.Kindly confirm the pre-requests that supports both such asOS,Ram,diskMSDTCetc.....

multi-valued report parameter weirdness

Posted: 11 Sep 2013 06:45 PM PDT

SSRS 2012, SQL 2012I watched Brian Knight's video on filtering a report using a multi-valued parameter (here:[url]http://www.sqlservercentral.com/articles/Video/64369/[/url]), and after seemingly forever, I got it to work. The weird thing is that if I used a stored procedure and tried to use IN(@MultivaluedParam)inside the stored procedure, it would fail.Here's the signature of the stored procedure:ALTER PROC [dbo].[uspHouseBuildInfo] @FromDate DATETIME, @ToDate DATETIME, @BuildEventType VARCHAR(60)AS...The only way I could get it to work was to copy the entire select statement from the stored procedure into the DataSet's query property, which I thought was odd. Yes, I know I could write the query better, but here it is.[code="sql"]SELECT x.HouseID , x.Homeowner , x.StartDate , x.hBuildSiteID , x.SiteName , x.HouseBuildDate , x.BuildDayNo , x.BuildMonth , x.BuildWeek , x.BuildEventType FROM ( SELECT h.HouseID, h.Homeowner, h.StartDate, h.hBuildSiteID, bs.SiteName, BuildDates.HouseBuildDate , ROW_NUMBER() OVER (PARTITION BY h.HouseID ORDER BY [HouseBuildDate]) AS BuildDayNo , Month(HouseBuildDate) AS BuildMonth , FLOOR((ROW_NUMBER() OVER (PARTITION BY h.HouseID ORDER BY [HouseBuildDate])+1)/2) AS BuildWeek , CASE WHEN FLOOR((ROW_NUMBER() OVER (PARTITION BY h.HouseID ORDER BY [HouseBuildDate])+1)/2) = 1 THEN 'Framing' WHEN FLOOR((ROW_NUMBER() OVER (PARTITION BY h.HouseID ORDER BY [HouseBuildDate])+1)/2) = 2 THEN 'Insulation & Siding' WHEN FLOOR((ROW_NUMBER() OVER (PARTITION BY h.HouseID ORDER BY [HouseBuildDate])+1)/2) = 3 THEN 'Paint & Trim' WHEN FLOOR((ROW_NUMBER() OVER (PARTITION BY h.HouseID ORDER BY [HouseBuildDate])+1)/2) = 4 THEN 'Landscaping & Hardware' END AS BuildEventType -- end case statement FROM House AS h INNER JOIN BuildSite AS bs ON h.hBuildSiteID = bs.SiteID INNER JOIN BuildDates ON h.HouseID = BuildDates.bhHouseID WHERE BuildDates.HouseBuildDate BETWEEN @FromDate AND @ToDate ) x WHERE x.BuildEventType IN (@BuildEventType);[/code]originally, I had the whole query designed as a stored procedure, and just based the report on that - until no matter what I tried, the multi-valued parameter would cause the query to fail. Okay, enough repeating myself!My question is this: Did I do something wrong in my stored procedure, or why dd this not work when I tried to pass a multi-valued parameter to my dataset? The [ ] multi-values property of the parameter is checked.... so what did I miss?Thanks!Pieter

Management/SQL Server Logs

Posted: 11 Sep 2013 03:09 AM PDT

Hi All,Our sever logs show a lot login failed Messages, we actually don't feel we have login problems. Even during night times, we believe no body works on, no SSIS package is scheduled. Following are examples, it happened to all the databases in the server.09/11/2013 00:12:49,Logon,Unknown,Login failed for user 'NT AUTHORITY\SYSTEM'. Reason: Failed to open the explicitly specified database 'DBNAME1'. [CLIENT: XXX.XX.X.XX]09/11/2013 00:12:49,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 38.09/11/2013 00:12:49,Logon,Unknown,Login failed for user 'NT AUTHORITY\SYSTEM'. Reason: Failed to open the explicitly specified database 'DBNAME2'. [CLIENT: XXX.XX.X.XX]09/11/2013 00:12:49,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 38.09/11/2013 00:12:49,Logon,Unknown,Login failed for user 'NT AUTHORITY\SYSTEM'. Reason: Failed to open the explicitly specified database 'ReportServer'. [CLIENT: XXX.XX.X.XX]09/11/2013 00:12:49,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 38.Can anyone let me know probably what causes this issue? Thanks in advance!

Serious bug in SQL Server 2012 SP1, due to msiexec process keep running

Posted: 11 Sep 2013 07:07 AM PDT

Cumulative Update 2 (CU2) for SQL Server 2012 is a [b]very important patch [/b]that you should [b]APPLY AS SOON AS POSSIBLE.[/b]There is a[b] serious bug in SP1 [/b]that is bloating the registry hive, because msiexec.exe processes keep running, even after rebooting and can use almost 100% of the CPU constantly. Windows will crash and you need to reinstall Windows when the registry hive reaches 2GB in size!If you look in the Eventlog, the following warnings are logged repeatedly:EventId: 1004 Source: MsiInstaller Description: Detection of product '{A7037EB2-F953-4B12-B843-195F4D988DA1}', feature 'SQL_Tools_Ans', Component '{0CECE655-2A0F-4593-AF4B-EFC31D622982}' failed. The resource'' does not exist.EventId: 1001 Source: MsiInstaller Description: Detection of product '{A7037EB2-F953-4B12-B843-195F4D988DA1}', feature 'SQL_Tools_Ans' failed during request for component '{6E985C15-8B6D-413D-B456-4F624D9C11C2}'Read more at:[url=http://blogs.msdn.com/b/sqljourney/archive/2012/10/25/why-the-registry-size-can-cause-problems-with-your-sql-2012-alwayson-setup.aspx]http://blogs.msdn.com/b/sqljourney/archive/2012/10/25/why-the-registry-size-can-cause-problems-with-your-sql-2012-alwayson-setup.aspx[/url][url=https://connect.microsoft.com/SQLServer/feedback/details/770630/msiexec-exe-processes-keep-running-after-installation-of-sql-server-2012-sp1]https://connect.microsoft.com/SQLServer/feedback/details/770630/msiexec-exe-processes-keep-running-after-installation-of-sql-server-2012-sp1[/url][url=https://support.microsoft.com/kb/2793634]https://support.microsoft.com/kb/2793634[/url]
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Search This Blog