Is there a way to find out when a patch was last applied to an instance?
As far as I know your only option there would be to look at the add/remove programs list (or dump this data from the registry to make it easier to deal with) and get that info from there. SQL Server doesn’t track that within the system databases.
View Answer
| October 4, 2011 5:56 PM
SQL instance, SQL Server, SQL Server security, SQL Server User Instances
As far as I know your only option there would be to look at the add/remove programs list (or dump this data from the registry to make it easier to deal with) and get that info from there. SQL Server doesn’t track that within the system databases.
View Answer
| October 4, 2011 5:56 PM
SQL instance, SQL Server, SQL Server security, SQL Server User Instances
Halt audit trace if audit file doesn’t rollover
SQL Server 2005 doesn’t have auditing, but SQL Server 2008 does. If you edit the Audit in SSMS one of the options is to shut down the SQL Server in the event of an audit failure. I normally recommend not going this as if you do and the server shuts down you’ve got no way [...]
View Answer
| September 30, 2011 6:08 PM
Audit File Rollover, Audit Trace, SQL audit, SQL Security, SQL Server 2005, SQL Server 2008
SQL Server 2005 doesn’t have auditing, but SQL Server 2008 does. If you edit the Audit in SSMS one of the options is to shut down the SQL Server in the event of an audit failure. I normally recommend not going this as if you do and the server shuts down you’ve got no way [...]
View Answer
| September 30, 2011 6:08 PM
Audit File Rollover, Audit Trace, SQL audit, SQL Security, SQL Server 2005, SQL Server 2008
Open IT Forum: Does the Windows 8 secure boot and Linux clash affect you?
Beyond what my blog post states, that Melanie referenced, even if Microsoft attempts to take out the competition, there’s a lot of legal issues that are going to (and already have) arisen. As linked in my post: http://www.zdnet.com.au/linux-users-threaten-microsoft-with-accc-339323063.htm People are already threatening to sue Microsoft for anti-trust violations if Secure Boot eliminates the Linux possibility. [...]
View Answer
| September 29, 2011 2:38 PM
AS/400, Business Intelligence, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Open IT Forum, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows 8, Windows Server
Beyond what my blog post states, that Melanie referenced, even if Microsoft attempts to take out the competition, there’s a lot of legal issues that are going to (and already have) arisen. As linked in my post: http://www.zdnet.com.au/linux-users-threaten-microsoft-with-accc-339323063.htm People are already threatening to sue Microsoft for anti-trust violations if Secure Boot eliminates the Linux possibility. [...]
View Answer
| September 29, 2011 2:38 PM
AS/400, Business Intelligence, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Open IT Forum, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows 8, Windows Server
Challenge improving query performance on large tables
Start by getting rid in the index scan by adding a non-clustered index. If you can post the sqlplan file somewhere I can take a look at it.
View Answer
| September 27, 2011 11:55 PM
Query optimization, Query performance, SQL query optimization, SQL Server 2008, SQL Server 2008 R2
Start by getting rid in the index scan by adding a non-clustered index. If you can post the sqlplan file somewhere I can take a look at it.
View Answer
| September 27, 2011 11:55 PM
Query optimization, Query performance, SQL query optimization, SQL Server 2008, SQL Server 2008 R2
Open IT Forum: Will HP be a worthy cloud contender?
Good luck with the book,everyone always brings this up! Enjoy http://www.nikemallchina.com, Retail and wholesale NIKEćAdidas’s running shoes, soccer shoes, basketball shoes,and so on.
View Answer
| September 27, 2011 8:01 AM
AS/400, Business Intelligence, Channel, CIO, Cloud Computing, CRM, Database, DataCenter, Development, Exchange, Hewlett-Packard, HP, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Open IT Forum, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
Good luck with the book,everyone always brings this up! Enjoy http://www.nikemallchina.com, Retail and wholesale NIKEćAdidas’s running shoes, soccer shoes, basketball shoes,and so on.
View Answer
| September 27, 2011 8:01 AM
AS/400, Business Intelligence, Channel, CIO, Cloud Computing, CRM, Database, DataCenter, Development, Exchange, Hewlett-Packard, HP, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Open IT Forum, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
SSRS authentication in workgroup environment
Users won’t be able to authenticate automatically in a workgroup. The server must prompt them for credentials, and the credentials that they enter much be users created on the server which is running SSRS.
View Answer
| September 26, 2011 6:47 PM
Reporting Services, Reporting Services Configuration Manager, SSRS, Windows 7, Workgroup Servers, Workgroups
Users won’t be able to authenticate automatically in a workgroup. The server must prompt them for credentials, and the credentials that they enter much be users created on the server which is running SSRS.
View Answer
| September 26, 2011 6:47 PM
Reporting Services, Reporting Services Configuration Manager, SSRS, Windows 7, Workgroup Servers, Workgroups
Open IT Forum: Goals to round out 2011
Open IT Forum: Goals to round out 2011 – The goals that have been set for our department to finish out this year (2011) and move into 2012 are simple; establish a base line of where we are currently with our software (back office) and begin the planning to fully implement the new back office [...]
View Answer
| September 26, 2011 1:26 PM
AS/400, Bounties, Business Intelligence, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Open IT Forum, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
Open IT Forum: Goals to round out 2011 – The goals that have been set for our department to finish out this year (2011) and move into 2012 are simple; establish a base line of where we are currently with our software (back office) and begin the planning to fully implement the new back office [...]
View Answer
| September 26, 2011 1:26 PM
AS/400, Bounties, Business Intelligence, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Open IT Forum, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
Use of database backup from lower version to higher version of sqlserver
Just take the backup file, copy it to the SQL 2008 server and restore it. SQL Server will upgrade the database for you automatically.
View Answer
| September 26, 2011 2:05 AM
SQL Server 2000, SQL Server 2008, SQL Server database
Just take the backup file, copy it to the SQL 2008 server and restore it. SQL Server will upgrade the database for you automatically.
View Answer
| September 26, 2011 2:05 AM
SQL Server 2000, SQL Server 2008, SQL Server database
Reg:Problem with SSAS
You can load SSAS 2005 cubes from any data source including SQL Server 2008. What kind of cubes are they? What storage model are you using? How are you loading the cubes?
View Answer
| September 26, 2011 2:04 AM
SQL Server 2005, SQL Server 2008, SQL Server migration, SSAS, SSAS 2005
You can load SSAS 2005 cubes from any data source including SQL Server 2008. What kind of cubes are they? What storage model are you using? How are you loading the cubes?
View Answer
| September 26, 2011 2:04 AM
SQL Server 2005, SQL Server 2008, SQL Server migration, SSAS, SSAS 2005
sys.conversation_endpoints build up
There’s nothing wrong with Service Broker. Are you doing an END CONVERSATION on the sending side as well? Service Broker requires a two phase commit to end the conversation. You should have an activated stored procedure on the sending queue on the sending server which closed the conversations when messages arrive in the sending queue.
View Answer
| September 26, 2011 2:02 AM
SQL Server 2008, SQL Server 2008 R2, SQL Server Service Broker, SQL Service Broker
There’s nothing wrong with Service Broker. Are you doing an END CONVERSATION on the sending side as well? Service Broker requires a two phase commit to end the conversation. You should have an activated stored procedure on the sending queue on the sending server which closed the conversations when messages arrive in the sending queue.
View Answer
| September 26, 2011 2:02 AM
SQL Server 2008, SQL Server 2008 R2, SQL Server Service Broker, SQL Service Broker
connecting to SQL server with mdf files
Storing the database in the App_Data directory usually isn’t the best idea. It wouldn’t be all that hard for someone to download the database from the website. Instead of having the AttachDbFilename parameter in there, simply attach the instance to the SQL Server and connect to it like a normal application would.
View Answer
| September 26, 2011 2:00 AM
.MDF files, SQL Server 2008, SQL Server 2008 R2
Storing the database in the App_Data directory usually isn’t the best idea. It wouldn’t be all that hard for someone to download the database from the website. Instead of having the AttachDbFilename parameter in there, simply attach the instance to the SQL Server and connect to it like a normal application would.
View Answer
| September 26, 2011 2:00 AM
.MDF files, SQL Server 2008, SQL Server 2008 R2
Create new SQL 2008 database in external drive
Yes you can move the database. In Management Studio right click on the database and select all tasks then detach database. Then move the files, then you can attach the database by right clicking on “Databases” in the object explorer of Management Studio and select all tasks then attach database. Find the file and select [...]
View Answer
| September 21, 2011 8:36 AM
External Disk Drives, SQL Database, SQL Express, SQL Express 2008
Yes you can move the database. In Management Studio right click on the database and select all tasks then detach database. Then move the files, then you can attach the database by right clicking on “Databases” in the object explorer of Management Studio and select all tasks then attach database. Find the file and select [...]
View Answer
| September 21, 2011 8:36 AM
External Disk Drives, SQL Database, SQL Express, SQL Express 2008
Add/Rename SQL Server 2005 Server Name
What shows up when you query the sys.servers catalog view?
View Answer
| September 21, 2011 8:32 AM
SQL Server, SQL Server 2005, SQL Server name
What shows up when you query the sys.servers catalog view?
View Answer
| September 21, 2011 8:32 AM
SQL Server, SQL Server 2005, SQL Server name
Free IT Book: Official Cert Guide for CCNP Security SECURE 642-637
I just answered the Cisco ASA question <a href=”http://itknowledgeexchange.techtarget.com/itanswers/asa/#viewquestion”>here</a>. Check it out! I LOVE CISCO!
View Answer
| September 20, 2011 4:46 PM
AS/400, Business Intelligence, Certification preparation, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, Giveaways, IT Books, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, Security certifications, SQL Server, Storage, Virtualization, VoIP, Windows Server
I just answered the Cisco ASA question <a href=”http://itknowledgeexchange.techtarget.com/itanswers/asa/#viewquestion”>here</a>. Check it out! I LOVE CISCO!
View Answer
| September 20, 2011 4:46 PM
AS/400, Business Intelligence, Certification preparation, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, Giveaways, IT Books, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, Security certifications, SQL Server, Storage, Virtualization, VoIP, Windows Server
Free IT Book: The Python Standard Library by Example
Hi, I’ve posted an answer which you can check in the following url: http://itknowledgeexchange.techtarget.com/itanswers/power-shell-script-change-screen-resolutions/ Regards
View Answer
| September 19, 2011 10:35 PM
AS/400, Business Intelligence, Channel, CIO, Contests, CRM, Database, DataCenter, Development, Exchange, Giveaways, IT Books, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
Hi, I’ve posted an answer which you can check in the following url: http://itknowledgeexchange.techtarget.com/itanswers/power-shell-script-change-screen-resolutions/ Regards
View Answer
| September 19, 2011 10:35 PM
AS/400, Business Intelligence, Channel, CIO, Contests, CRM, Database, DataCenter, Development, Exchange, Giveaways, IT Books, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
Open IT Forum: What should system documentation look like?
My documentation is written to be understood by the least knowledgable person who will be using it. If I’m writing disaster recovery procedures, they are written to be understood by the least qualified and knowledgable person in our department. This is no means a reflection on their abilities, but simply an opinion that if they [...]
View Answer
| September 15, 2011 2:15 PM
AS/400, Business Intelligence, Channel, CIO, CRM, DataCenter, Development, Exchange, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Open IT Forum, Oracle, SAP, Security, SQL Server, Storage, System Documentation, Virtualization, VoIP, Windows Server
My documentation is written to be understood by the least knowledgable person who will be using it. If I’m writing disaster recovery procedures, they are written to be understood by the least qualified and knowledgable person in our department. This is no means a reflection on their abilities, but simply an opinion that if they [...]
View Answer
| September 15, 2011 2:15 PM
AS/400, Business Intelligence, Channel, CIO, CRM, DataCenter, Development, Exchange, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Open IT Forum, Oracle, SAP, Security, SQL Server, Storage, System Documentation, Virtualization, VoIP, Windows Server
Open IT Forum: IT’s role in customer service
A timely response is always encouraged and just good customer service of course. Nothing worse than asking for help and then waiting hours or even days for a response. If you say someone will be with the customer shortly, don’t keep them waiting forever please! I don’t mind giving a level of severity. If I [...]
View Answer
| March 5, 2013 3:41 PM
AS/400, Business Intelligence, Channel, CIO, CRM, Customer service, Database, DataCenter, Development, Exchange, IT project management, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Open IT Forum, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
A timely response is always encouraged and just good customer service of course. Nothing worse than asking for help and then waiting hours or even days for a response. If you say someone will be with the customer shortly, don’t keep them waiting forever please! I don’t mind giving a level of severity. If I [...]
View Answer
| March 5, 2013 3:41 PM
AS/400, Business Intelligence, Channel, CIO, CRM, Customer service, Database, DataCenter, Development, Exchange, IT project management, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Open IT Forum, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
Visual Basic and SQL database design
As others have suggested, the table needs to be broken up and normalized. In a salary application, I venture to state that about 70% to 80% of data is static month to month. Consequently your monthly replication of 27000 of rows (with 37 columns) is a not good design. You really need to take a [...]
View Answer
| September 13, 2011 7:18 PM
Database design, SQL Database, VB.NET, Visual Basic, Visual Basic .NET
As others have suggested, the table needs to be broken up and normalized. In a salary application, I venture to state that about 70% to 80% of data is static month to month. Consequently your monthly replication of 27000 of rows (with 37 columns) is a not good design. You really need to take a [...]
View Answer
| September 13, 2011 7:18 PM
Database design, SQL Database, VB.NET, Visual Basic, Visual Basic .NET
Open IT Forum: How do you prepare your data center for severe weather?
The main problem in our area are ice storms, freezing rain, severe thunderstorms and tornados. Most of these result in power outages which is dealt with by UPS and backup generators. Now our company has experienced growth over the past decade to the point where we are now beginning to implement 2 co-locations for our [...]
View Answer
| September 13, 2011 2:57 PM
AS/400, Business Intelligence, CIO, CRM, Data Center management, Database, DataCenter, Development, Disaster Recovery, Disaster Recovery Plan, Exchange, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Open IT Forum, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
The main problem in our area are ice storms, freezing rain, severe thunderstorms and tornados. Most of these result in power outages which is dealt with by UPS and backup generators. Now our company has experienced growth over the past decade to the point where we are now beginning to implement 2 co-locations for our [...]
View Answer
| September 13, 2011 2:57 PM
AS/400, Business Intelligence, CIO, CRM, Data Center management, Database, DataCenter, Development, Disaster Recovery, Disaster Recovery Plan, Exchange, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Open IT Forum, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
SQL Server Help
Dynamic SQL is the only way that you’ll be able to do this. The code you have looks fine to me. [kccrosser] There are a couple of key things to do to speed this up – a LOT. 1. eliminate those “select top 1 …” queries. Those are causing a table scan and sort, where [...]
View Answer
| September 10, 2011 1:03 AM
INSERT SELECT statement, SQL Records, SQL Server, SQL Server administration, Stored Procedures
Dynamic SQL is the only way that you’ll be able to do this. The code you have looks fine to me. [kccrosser] There are a couple of key things to do to speed this up – a LOT. 1. eliminate those “select top 1 …” queries. Those are causing a table scan and sort, where [...]
View Answer
| September 10, 2011 1:03 AM
INSERT SELECT statement, SQL Records, SQL Server, SQL Server administration, Stored Procedures
