SSRS 2008 R2 Trendlines
I cannot find out how to add trendlines to my SSRS 2008 R2 report. TechNet http://technet.microsoft.com/en-us/library/dd207034.aspx refers to a ‘Values’ area and an option to ‘Add Calculated Series’. The ‘Values’ area I see does nothing on a “Right-click” and the option to “Add Calculated Series” I cannot find anywhere.
Answer Question
| October 25, 2011 8:19 AM
SQL Server Reporting Services, SQL Server Reporting Services 2008, SSRS, SSRS 2008
I cannot find out how to add trendlines to my SSRS 2008 R2 report. TechNet http://technet.microsoft.com/en-us/library/dd207034.aspx refers to a ‘Values’ area and an option to ‘Add Calculated Series’. The ‘Values’ area I see does nothing on a “Right-click” and the option to “Add Calculated Series” I cannot find anywhere.
Answer Question
| October 25, 2011 8:19 AM
SQL Server Reporting Services, SQL Server Reporting Services 2008, SSRS, SSRS 2008
MVC Architecure and ASP.net programming
Are Action Filters, model binding & validation new features in MVC?
Answer Question
| October 19, 2011 1:54 PM
ASP.NET Web applications, MVC, SQL Server 2005
Are Action Filters, model binding & validation new features in MVC?
Answer Question
| October 19, 2011 1:54 PM
ASP.NET Web applications, MVC, SQL Server 2005
Free IT Book: Demystifying the Virtual Desktop
Interested in desktop virtualization? This week’s free IT book is just what you need. Michael Fox’s Demystifying the Virtual Desktop Starting with Desktop Virtualization is a quick read that breaks down the business and technical complexities of virtual desktops. Simply answer one of five questions and post the link to your answer in the discussion [...]
Answer Question
| May 4, 2012 2:23 PM
AS/400, Business Intelligence, Channel, CIO, 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
Interested in desktop virtualization? This week’s free IT book is just what you need. Michael Fox’s Demystifying the Virtual Desktop Starting with Desktop Virtualization is a quick read that breaks down the business and technical complexities of virtual desktops. Simply answer one of five questions and post the link to your answer in the discussion [...]
Answer Question
| May 4, 2012 2:23 PM
AS/400, Business Intelligence, Channel, CIO, 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 tech CEO would you vote for?
Michael Morisy recently reported on a primary of off-ticket, independent candidates, which included Cisco CEO John Chambers. Not to get too political, but we were wondering if there were particular tech CEOs that you admired for one reason or another. Share your thoughts — or your vote — and we’ll share 50 Knowledge Points!
Answer Question
| March 9, 2012 7:46 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 Server
Michael Morisy recently reported on a primary of off-ticket, independent candidates, which included Cisco CEO John Chambers. Not to get too political, but we were wondering if there were particular tech CEOs that you admired for one reason or another. Share your thoughts — or your vote — and we’ll share 50 Knowledge Points!
Answer Question
| March 9, 2012 7:46 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 Server
conversion of oracle trigger to MS SQL
how can i convert an oracle trigger into MS-SQL?
Answer Question
| October 12, 2011 1:49 PM
MSSQL, Oracle triggers, SQL connectivity, SQL Server
how can i convert an oracle trigger into MS-SQL?
Answer Question
| October 12, 2011 1:49 PM
MSSQL, Oracle triggers, SQL connectivity, SQL Server
SQL Server backup to remote internet location
We have one server with 2 SQL databases with size 1.5GB and 6GB, Daily new transactions are added to the system. Now we want a solution that this SQL gets backed up / replicated at some remote internet location on daily basis. Since we cannot transpot full 1.5GB file or 6GB file on daily basis, [...]
Answer Question
| October 20, 2011 10:21 AM
SQL Backup, SQL Database, SQL Server, SQL Server backup
We have one server with 2 SQL databases with size 1.5GB and 6GB, Daily new transactions are added to the system. Now we want a solution that this SQL gets backed up / replicated at some remote internet location on daily basis. Since we cannot transpot full 1.5GB file or 6GB file on daily basis, [...]
Answer Question
| October 20, 2011 10:21 AM
SQL Backup, SQL Database, SQL Server, SQL Server backup
cluster install node failure when adding
I installed a sql server 2008 cluster, first node went fine, however the 2nd node install fails with the following installing failover node sql server 2008 This resource does not have all the nodes of the cluster listed as ‘Possible Owners’. The group that this resource is a member of will not be able to [...]
Answer Question
| October 11, 2011 8:27 PM
Cluster management, SQL Server 2008, SQL Server clustering
I installed a sql server 2008 cluster, first node went fine, however the 2nd node install fails with the following installing failover node sql server 2008 This resource does not have all the nodes of the cluster listed as ‘Possible Owners’. The group that this resource is a member of will not be able to [...]
Answer Question
| October 11, 2011 8:27 PM
Cluster management, SQL Server 2008, SQL Server clustering
EXTENDED: IT Scripts Contest now ends October 17
It’s not too late! IT Knowledge Exchange is extending its latest contest: Is your script 3-dimensional? You don’t have to be an IT Script Shakespeare to get in on the contest: Did you know you can win a Nintendo 3DS for just leaving a great comment on one of the entries? Check out the entries [...]
Answer Question
| March 31, 2012 3:30 PM
AS/400, Business Intelligence, Channel, CIO, Contests, CRM, Database, DataCenter, Development, Exchange, Giveaways, IT Scripts, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
It’s not too late! IT Knowledge Exchange is extending its latest contest: Is your script 3-dimensional? You don’t have to be an IT Script Shakespeare to get in on the contest: Did you know you can win a Nintendo 3DS for just leaving a great comment on one of the entries? Check out the entries [...]
Answer Question
| March 31, 2012 3:30 PM
AS/400, Business Intelligence, Channel, CIO, Contests, CRM, Database, DataCenter, Development, Exchange, Giveaways, IT Scripts, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
Return only one word– SQL
Hello, I have a column called Profile in a table and I am searching for a specific word in that column. I use the keyword LIKE with the wildcard (%) and that is working fine, but how do I have the query only return that word and not all the text in the Profile column. [...]
Answer Question
| March 31, 2012 7:12 PM
Oracle, Oracle SQL, SQL, SQL Server
Hello, I have a column called Profile in a table and I am searching for a specific word in that column. I use the keyword LIKE with the wildcard (%) and that is working fine, but how do I have the query only return that word and not all the text in the Profile column. [...]
Answer Question
| March 31, 2012 7:12 PM
Oracle, Oracle SQL, SQL, SQL Server
How can do iSQl*Plus login for DBA
I want to create iSQL*Plus login for DBA. How can i do this ?
Answer Question
| March 31, 2012 4:25 PM
DBA, iSQL*Plus, SQL, SQL Plus, SQL Server
I want to create iSQL*Plus login for DBA. How can i do this ?
Answer Question
| March 31, 2012 4:25 PM
DBA, iSQL*Plus, SQL, SQL Plus, SQL Server
Error Message in SQL Server 2008 code.
Hi, I am currently going through the Tutorials on SQL Server Management Studio 2008 R2. One of the samples instructs me to run the following code: SELECT Mgr.EmployeeID AS MgrID, Mgr.LoginID AS Manager, Emp.EmployeeID AS E_ID, Emp.LoginID, FROM EmployeeDemo AS Emp LEFT JOIN EmployeeDemo AS Mgr ON Emp.ManagerID = Mgr.EmployeeID ORDER BY MgrID, E_ID; [em]When [...]
Answer Question
| March 31, 2012 11:20 AM
SQL Query, SQL Server 2008 R2, SQL Server Management Studio, SSMS 2008
Hi, I am currently going through the Tutorials on SQL Server Management Studio 2008 R2. One of the samples instructs me to run the following code: SELECT Mgr.EmployeeID AS MgrID, Mgr.LoginID AS Manager, Emp.EmployeeID AS E_ID, Emp.LoginID, FROM EmployeeDemo AS Emp LEFT JOIN EmployeeDemo AS Mgr ON Emp.ManagerID = Mgr.EmployeeID ORDER BY MgrID, E_ID; [em]When [...]
Answer Question
| March 31, 2012 11:20 AM
SQL Query, SQL Server 2008 R2, SQL Server Management Studio, SSMS 2008
Is there a way to find out when a patch was last applied to an instance?
Is there a way to find out the date a SQL Server instance was last patched? I need to keep track of dates each of my instances had a patch applied whether it be a security patch, hotfix or service pack. I looked in the ServerProperty function but did not see anything that would return [...]
Answer Question
| March 31, 2012 2:20 PM
SQL instance, SQL Server, SQL Server security, SQL Server User Instances
Is there a way to find out the date a SQL Server instance was last patched? I need to keep track of dates each of my instances had a patch applied whether it be a security patch, hotfix or service pack. I looked in the ServerProperty function but did not see anything that would return [...]
Answer Question
| March 31, 2012 2:20 PM
SQL instance, SQL Server, SQL Server security, SQL Server User Instances
Open IT Forum: What do you want to see from IT Knowledge Exchange in 2012?
We asked what your goals are for late 2011 and early 2012, but now we want to know what you hope to see from the IT Knowledge Exchange community. If there’s a functionality you would like to see, or a topic you want to know more about, let us know in the discussion section! Don’t [...]
Answer Question
| April 28, 2012 4:44 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 Server
We asked what your goals are for late 2011 and early 2012, but now we want to know what you hope to see from the IT Knowledge Exchange community. If there’s a functionality you would like to see, or a topic you want to know more about, let us know in the discussion section! Don’t [...]
Answer Question
| April 28, 2012 4:44 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 Server
Free IT Book: IP Networking
We’re giving away a detailed and practical overview of TCP/IP networking in IP Networking. From the publishers: “IP Networking takes you from a broad and basic knowledge of IP addressing and routing to a solid skill level with how hosts, switches, and routers collectively deliver IP packets in modern corporate networks, helping prepare you for [...]
Answer Question
| March 31, 2012 4:00 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
We’re giving away a detailed and practical overview of TCP/IP networking in IP Networking. From the publishers: “IP Networking takes you from a broad and basic knowledge of IP addressing and routing to a solid skill level with how hosts, switches, and routers collectively deliver IP packets in modern corporate networks, helping prepare you for [...]
Answer Question
| March 31, 2012 4:00 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
Halt audit trace if audit file doesn’t rollover
I have a security requirement for SQL Server 2005 and 2008: “SQL Server shall be configured to halt if a failure in audit file rollover occurs”. How do I accomplish this?
Answer Question
| March 31, 2012 4:59 PM
Audit File Rollover, Audit Trace, SQL audit, SQL Security, SQL Server 2005, SQL Server 2008
I have a security requirement for SQL Server 2005 and 2008: “SQL Server shall be configured to halt if a failure in audit file rollover occurs”. How do I accomplish this?
Answer Question
| March 31, 2012 4:59 PM
Audit File Rollover, Audit Trace, SQL audit, SQL Security, SQL Server 2005, SQL Server 2008
Setup SSIS for a group of developers.
I newbie and I need help here. We are doing a new MS SQL and BI setup for our developers here. We have a team of 12 developers here doing different projects. We have one server with MS SQL being installed. This single MS SQL will be setup with each individual database for the projects that [...]
Answer Question
| March 31, 2012 3:16 AM
SQL 2008, SQL Server, SQL Server 2008, SSIS
I newbie and I need help here. We are doing a new MS SQL and BI setup for our developers here. We have a team of 12 developers here doing different projects. We have one server with MS SQL being installed. This single MS SQL will be setup with each individual database for the projects that [...]
Answer Question
| March 31, 2012 3:16 AM
SQL 2008, SQL Server, SQL Server 2008, SSIS
Open IT Forum: Does the Windows 8 secure boot and Linux clash affect you?
We want to know how this “little” inconvenience is affecting the world of Linux users out there. Air your grievances or worries for the future of Linux right here, and we’ll send you 50 Knowledge Points!
Answer Question
| March 31, 2012 5:20 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
We want to know how this “little” inconvenience is affecting the world of Linux users out there. Air your grievances or worries for the future of Linux right here, and we’ll send you 50 Knowledge Points!
Answer Question
| March 31, 2012 5:20 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
Hi, Here’s the structure of the db I’m using: * Table frs_ArticlesBDFournisseur which contains article main data.One row per article/color. Key is Refrefart (int). Size is over 220000 rows at the momemt. Only index is the PK (clusterred). * Table frs_ArticlesBDFournisseurTaille contains all the various sizes and barcode for the corresponding article/color from the previous [...]
Answer Question
| March 31, 2012 2:21 PM
Query optimization, Query performance, SQL query optimization, SQL Server 2008, SQL Server 2008 R2
Hi, Here’s the structure of the db I’m using: * Table frs_ArticlesBDFournisseur which contains article main data.One row per article/color. Key is Refrefart (int). Size is over 220000 rows at the momemt. Only index is the PK (clusterred). * Table frs_ArticlesBDFournisseurTaille contains all the various sizes and barcode for the corresponding article/color from the previous [...]
Answer Question
| March 31, 2012 2:21 PM
Query optimization, Query performance, SQL query optimization, SQL Server 2008, SQL Server 2008 R2
How to configure parameters display in SSRS 2008?
Hi, I know it wasn’t possible in ssrs 2005 to have parameters displayed into more than 2 columns. My question is has it be solved in ssrs 2008r2 ? If yes, how can I do it ? If no, is there a possibility to walk around this issue ? Many thanks, Sonia
Answer Question
| March 31, 2012 11:29 AM
SQL Server Reporting Services, SQL Server Reporting Services 2008, SSRS 2008
Hi, I know it wasn’t possible in ssrs 2005 to have parameters displayed into more than 2 columns. My question is has it be solved in ssrs 2008r2 ? If yes, how can I do it ? If no, is there a possibility to walk around this issue ? Many thanks, Sonia
Answer Question
| March 31, 2012 11:29 AM
SQL Server Reporting Services, SQL Server Reporting Services 2008, SSRS 2008
SSRS authentication in workgroup environment
Can a workgroup be configured to authenticate to reporting services to run reports? If so, could someone please assist me in this security setup as we are currently experiencing difficulty. Our Windows 7 “server” authenticates fine but none of the current client computers are able. Thank you.
Answer Question
| March 31, 2012 2:51 PM
Reporting Services, Reporting Services Configuration Manager, SSRS, Windows 7, Workgroup Servers, Workgroups
Can a workgroup be configured to authenticate to reporting services to run reports? If so, could someone please assist me in this security setup as we are currently experiencing difficulty. Our Windows 7 “server” authenticates fine but none of the current client computers are able. Thank you.
Answer Question
| March 31, 2012 2:51 PM
Reporting Services, Reporting Services Configuration Manager, SSRS, Windows 7, Workgroup Servers, Workgroups
