Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Adding to SQL Server


Adding to SQL Server

Author
Message
Steve Jones
Steve Jones
SSC-Forever
SSC-Forever (40K reputation)SSC-Forever (40K reputation)SSC-Forever (40K reputation)SSC-Forever (40K reputation)SSC-Forever (40K reputation)SSC-Forever (40K reputation)SSC-Forever (40K reputation)SSC-Forever (40K reputation)

Group: Administrators
Points: 40542 Visits: 18846
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
My Blog: www.voiceofthedba.com
David.Poole
David.Poole
SSCarpal Tunnel
SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)

Group: General Forum Members
Points: 4381 Visits: 3174
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
JakobBindslet
JakobBindslet
Grasshopper
Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)

Group: General Forum Members
Points: 10 Visits: 234
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.
Steph Locke
Steph Locke
SSC Veteran
SSC Veteran (211 reputation)SSC Veteran (211 reputation)SSC Veteran (211 reputation)SSC Veteran (211 reputation)SSC Veteran (211 reputation)SSC Veteran (211 reputation)SSC Veteran (211 reputation)SSC Veteran (211 reputation)

Group: General Forum Members
Points: 211 Visits: 870
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.
Jeff_C
Jeff_C
SSC Journeyman
SSC Journeyman (88 reputation)SSC Journeyman (88 reputation)SSC Journeyman (88 reputation)SSC Journeyman (88 reputation)SSC Journeyman (88 reputation)SSC Journeyman (88 reputation)SSC Journeyman (88 reputation)SSC Journeyman (88 reputation)

Group: General Forum Members
Points: 88 Visits: 245
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.
Gary Varga
Gary Varga
SSChampion
SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)

Group: General Forum Members
Points: 10105 Visits: 6340
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!!!
Xavon
Xavon
Right there with Babe
Right there with Babe (768 reputation)Right there with Babe (768 reputation)Right there with Babe (768 reputation)Right there with Babe (768 reputation)Right there with Babe (768 reputation)Right there with Babe (768 reputation)Right there with Babe (768 reputation)Right there with Babe (768 reputation)

Group: General Forum Members
Points: 768 Visits: 452
A minor request, but I would very much like to have GREATEST() and LEAST() like MySQL has.
Steph Locke
Steph Locke
SSC Veteran
SSC Veteran (211 reputation)SSC Veteran (211 reputation)SSC Veteran (211 reputation)SSC Veteran (211 reputation)SSC Veteran (211 reputation)SSC Veteran (211 reputation)SSC Veteran (211 reputation)SSC Veteran (211 reputation)

Group: General Forum Members
Points: 211 Visits: 870
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() :-)
netmikem
netmikem
SSChasing Mays
SSChasing Mays (644 reputation)SSChasing Mays (644 reputation)SSChasing Mays (644 reputation)SSChasing Mays (644 reputation)SSChasing Mays (644 reputation)SSChasing Mays (644 reputation)SSChasing Mays (644 reputation)SSChasing Mays (644 reputation)

Group: General Forum Members
Points: 644 Visits: 360
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!



_Codeman_
_Codeman_
Forum Newbie
Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)

Group: General Forum Members
Points: 3 Visits: 25
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
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search