Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12345»»»

Adding to SQL Server Expand / Collapse
Author
Message
Posted Thursday, January 30, 2014 8:53 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 11:24 AM
Points: 32,781, Visits: 14,942
Comments posted to this topic are about the item Adding to SQL Server






Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1536623
Posted Friday, January 31, 2014 1:22 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 3:49 PM
Points: 2,866, Visits: 1,708
A sophisticated full-text search with sophisticated phonetic matching capability would go down a treat.

Being able to deploy onto Linux would be fantastic.

A formal metadata and lineage facility that takes into account replication, SSIS/AS/RS, linked servers, cross database dependencies etc.

I wouldn't worry about SSMS as long as there is Red-Gate


LinkedIn Profile
Newbie on www.simple-talk.com
Post #1536661
Posted Friday, January 31, 2014 1:32 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, April 03, 2014 3:07 AM
Points: 2, Visits: 156
My list of desired feature and improvements looks something like this:

Instance/cluster aware SSIS.

Scheduled Servicepack release schedule, like once per year (yes, I would consider this a feature!)

Many improvements to Management Studio, including, but not limited to
- GUI interface to some of the newer engine features, that require T-SQL to interact with.
- better stability, less freezes when an action in one window takes a long time complete.
- redesign of many "sub windows", so there is adequate space to the information they hold and they are resizeable.


Other areas, where improvements are overdue:
Cleanup in old system SPs and views, correct spelling mistakes.
Post #1536663
Posted Friday, January 31, 2014 2:14 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, April 09, 2014 6:00 AM
Points: 157, Visits: 792
A complete rebuild of SSRS so that central reporting can look better, deliver more value and take less time to develop.

Central reporting is necessary for day-to-day reports, high performance requirements, and anything that should be kept rigorously audited. By not putting any development into a tool fundamentally geared towards providing this function it increases risk within businesses as users find they can produce reports in Excel that look better and take less time to build. This is great except you start getting rogue departments who make decisions off of incorrect figures or are able to massage their figures and hide issues. I like self-service BI but I think there has to be a core suite of central reporting that covers the majority of the requirements within an organisation otherwise most people will spend their time building and maintaining spreadsheets.
Post #1536672
Posted Friday, January 31, 2014 4:27 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Wednesday, April 02, 2014 5:38 AM
Points: 65, Visits: 160
More around the automation side of things, to start with: -
A powershell aware installer.
A way to determine installed features, other than "Setup.exe /Action=RunDiscovery", a powershell cmdlet that returns a recordset maybe.

https://connect.microsoft.com/PowerShell/feedback/details/761518/sql-server-features-discovery-cmdlet

Both of these would help enterprise management.

Replication
Allow replication from one distribution database to another and then have multiple subscribes hanging off the second distribution database. Effectively this would mirror the possibilities within Sybase RepServer and their use of RSIs. The major benefit to this comes when replicating to multiple subscribers across a WAN. By sending the data across the wan once to what is effectively a staging DB, there is less traffic on the WAN.
Post #1536707
Posted Friday, January 31, 2014 4:31 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Wednesday, April 16, 2014 8:20 AM
Points: 4,862, Visits: 2,243
Integrated unit testing. I don't know any details. I know there are applications of various techniques out there. I just want something out of the box that is integrated into the tooling as part of the SDLC. Perhaps it could be something where it is architected so alternatives can be swapped in to appease (in a positive sense) the desire for open systems.

Gaz

-- Stop your grinnin' and drop your linen...they're everywhere!!!
Post #1536709
Posted Friday, January 31, 2014 6:46 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, April 07, 2014 7:08 AM
Points: 211, Visits: 63
A minor request, but I would very much like to have GREATEST() and LEAST() like MySQL has.
Post #1536761
Posted Friday, January 31, 2014 6:55 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, April 09, 2014 6:00 AM
Points: 157, Visits: 792
nickd-799913 (1/31/2014)
A minor request, but I would very much like to have GREATEST() and LEAST() like MySQL has.


Good point - let's get group_concat()
Post #1536765
Posted Friday, January 31, 2014 6:56 AM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: 2 days ago @ 7:39 AM
Points: 602, Visits: 302
I would like to see a simple, yet robust mechanism to ensure users cannot access an instance directly (i.e. via SSMS or whatever) when using Windows Integration. In other words, I would like to limit them to access through my front-end application only.

I've researched this before and the only options I could see were to use an application role (which has limitations), certificates (too complex?) or a logon trigger that checks what application the user is coming in using (not a particularly elegant solution in my opinion).

Surely the great minds at Microsoft could come up with a simple solution for this!



Post #1536766
Posted Friday, January 31, 2014 7:01 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, March 24, 2014 10:32 AM
Points: 1, Visits: 15
I would like to see a TRIM() or ALLTRIM() function build into SQL server in future versions instread of having to use the Ltrim(Rtrim()) combo.

-Codeman
Post #1536768
« Prev Topic | Next Topic »

Add to briefcase 12345»»»

Permissions Expand / Collapse